Hi,
I've been down so many dead ends trying to get something working, so
I'm really hoping someone can help out.
I need to access an Oracle database running on a Windows server from
Python running on Linux. I've tried building DCOracle2, but it seems
that the 'oracle-installclient-basic' thing I downloaded from the
Oracle site doesn't contain enough. I've tried various other
approaches, such as mxODBC/iODBC, but without much luck. I'm hoping to
not have to resort to a Windows solution.
Can someone help me figure out what combination of Python module,
Oracle download and/or ODBC driver will work?
Thanks,
Dan.
--
Dan Ellis, Computer Officer
North Lindsey College 6 2333
You don't want to use ODBC as that is a Windows interface
that doesn't natively exist on Linux. You can purchase
Linux ODBC interfaces from companies like EasySoft, but
if your program is running on Linux you will be much better
off with a native interface. ODBC overhead is quite large
and should be avoided whenever possible. You didn't say
which version of Oracle, but for 7 and 8 you can use http://www.zope.org/Products/DCOracle/
8i and above can be accessed using http://www.zope.org/Members/matt/dco2/
Access to remote Oracle databases is just done via TCP
connections.
Note: Our experience is that Oracle runs MUCH better
on Linux than Windows (as much as 5 times faster on
equivalent hardware). Are you sure you want the database
on Windows?
HTH,
Larry Bates
Syscon, Inc.
"Dan Ellis" <us****@electricwords.org> wrote in message
news:bf**************************@posting.google.c om... Hi,
I've been down so many dead ends trying to get something working, so I'm really hoping someone can help out.
I need to access an Oracle database running on a Windows server from Python running on Linux. I've tried building DCOracle2, but it seems that the 'oracle-installclient-basic' thing I downloaded from the Oracle site doesn't contain enough. I've tried various other approaches, such as mxODBC/iODBC, but without much luck. I'm hoping to not have to resort to a Windows solution.
Can someone help me figure out what combination of Python module, Oracle download and/or ODBC driver will work?
Thanks, Dan.
-- Dan Ellis, Computer Officer North Lindsey College
Dan Ellis wrote: Hi,
[...]
I need to access an Oracle database running on a Windows server from Python running on Linux. I've tried building DCOracle2, but it seems that the 'oracle-installclient-basic' thing I downloaded from the Oracle site doesn't contain enough. I've tried various other approaches, such as mxODBC/iODBC, but without much luck. I'm hoping to not have to resort to a Windows solution.
Can someone help me figure out what combination of Python module, Oracle download and/or ODBC driver will work?
Try cx_Oracle: http://www.computronix.com/utilities.shtml#Oracle
(and of course you need an Oracle client installation on your Linux
machine)
HTH,
Walter Dörwald
Dan Ellis wrote: Hi,
[...]
I need to access an Oracle database running on a Windows server from Python running on Linux. I've tried building DCOracle2, but it seems that the 'oracle-installclient-basic' thing I downloaded from the Oracle site doesn't contain enough. I've tried various other approaches, such as mxODBC/iODBC, but without much luck. I'm hoping to not have to resort to a Windows solution.
Can someone help me figure out what combination of Python module, Oracle download and/or ODBC driver will work?
Try cx_Oracle: http://www.computronix.com/utilities.shtml#Oracle
(and of course you need an Oracle client installation on your Linux
machine)
HTH,
Walter Dörwald
Larry Bates wrote: You don't want to use ODBC as that is a Windows interface that doesn't natively exist on Linux. You can purchase Linux ODBC interfaces from companies like EasySoft, but if your program is running on Linux you will be much better off with a native interface. ODBC overhead is quite large and should be avoided whenever possible.
I don't quite agree with this statement: it's an old myth
that was based on poor ODBC drivers. If you connect to a
database over a network, the network latency is what matters,
not the additional layering you do on the client or server.
ODBC gives you much more flexibility in terms of setting up
your database client - server and backend structure.
Tools like mxODBC let you tap into this flexibility from
Windows, Linux, Solaris, AIX, etc. with the additional
benefit of having to only write against one API for all
databases and on all platforms.
--
Marc-Andre Lemburg
eGenix.com
Professional Python Services directly from the Source (#1, Jul 16 2004) Python/Zope Consulting and Support ... http://www.egenix.com/ mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
__________________________________________________ ______________________
::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::
Dan Ellis wrote: Hi,
I've been down so many dead ends trying to get something working, so I'm really hoping someone can help out.
I need to access an Oracle database running on a Windows server from Python running on Linux. I've tried building DCOracle2, but it seems that the 'oracle-installclient-basic' thing I downloaded from the Oracle site doesn't contain enough. I've tried various other approaches, such as mxODBC/iODBC, but without much luck. I'm hoping to not have to resort to a Windows solution.
Can someone help me figure out what combination of Python module, Oracle download and/or ODBC driver will work?
The EasySoft Oracle drivers works nicely with mxODBC/unixODBC.
Other vendors of ODBC drivers for Oracle are: DataDirect,
OpenLink and a few others: http://www.sqlsummit.com/ODBCVend.htm
There's also an open-soruce Oracle ODBC driver: http://fndapl.fnal.gov/~dbox/oracle/odbc/
Naturally, the EasySoft driver works best with unixODBC and
the OpenLink one with iODBC (simply because those two companies
took over development of these ODBC managers).
--
Marc-Andre Lemburg
eGenix.com
Professional Python Services directly from the Source (#1, Jul 16 2004) Python/Zope Consulting and Support ... http://www.egenix.com/ mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
__________________________________________________ ______________________
::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::
Thanks to everyone who replied. I finally managed to get cx_Oracle
built against Oracle 9i, and it's now working sweeter than a sweet
thing with extra sugar on. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: duikboot |
last post by:
Hi all,
I'm trying to export a view tables from a Oracle database to a Mysql
database. I create insert statements (they look alright), but it all goes
wrong when I try to execute them in Mysql,...
|
by: Benson, John |
last post by:
Hi, I'm a non-Oracle guy just starting to use Python to explore Oracle.
I enclose the Python command prompt log for the usage example further
down with only the user, password and host names...
|
by: Greg Lindstrom |
last post by:
Greetings-
I am running Python 2.3.3 on HP-UX and would like to access an Oracle 9i
database. Looking through the vaults, I see 4 or 5 modules that might work
and was wondering if anyone is...
|
by: majk |
last post by:
hey!
Im looking for a db tutoral which covers accessing a Microsoft SQL database
on windows. I will be using VC++ if it matters. NO details just a basic
introduction!
Oracle DB access using...
|
by: Andrea M. Segovia |
last post by:
Hello,
I am a newbie to Oracle databases....
We have a visualization front-end tool connected to an Oracle back-end
database on a Tru64 UNIX server. We also have clients with MS access...
|
by: Jeff |
last post by:
Has anyone had any luck accessing an Oracle database from a web service?
I have a C# DLL with various code to query an Oracle database. If I call
the methods in this DLL from a Windows Forms...
|
by: Neo |
last post by:
Hi Everyone
I am trying to acces Oracle using oracle client classes
provided by .net in an asp .net application. But I keep on getting following
error
"System.Data.OracleClient requires Oracle...
|
by: Mark Brown |
last post by:
I'm trying to access an Oracle database vb.net. I found several examples.
I tried following each one, but I get the same error no matter what I try.
I don't really understand what the error means...
|
by: =?Utf-8?B?RGF2aWQrKw==?= |
last post by:
Hi,
I have been developing Web Services in VS2005. Usually I use the built in
server in VS2005 to test and develop the Web Service.
However I now want to make this Web Service available to...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |