Re: Native ODBC access for python on linux?

2005-07-15 Thread callmebill
All, This info was very helpful, and I'm up and running with MySQLdb on linux, and the native ODBC support on Windows. One last question I have: In vbs (specifically with .asp) I can make a connection to an ODBC provide _without_ the need to specify a system DSN in the Control Panel. It's easy

Re: Native ODBC access for python on linux?

2005-07-15 Thread Thomas Bartkus
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] All, This info was very helpful, and I'm up and running with MySQLdb on linux, and the native ODBC support on Windows. One last question I have: In vbs (specifically with .asp) I can make a connection to an ODBC provide _without_

Re: Native ODBC access for python on linux?

2005-07-15 Thread callmebill
I know... I'm expecting pain, and when that pain doesn't arrive I assume that I did something wrong. Actually, I was using the odbc/dbi stuff that ships with the win32 distribution for my windows work, and using MySQLdb for my linux work. Most of the code is the same. But I suppose the big

Re: Native ODBC access for python on linux?

2005-07-15 Thread Grig Gheorghiu
That's exactly the way to go. In my case, I'm using cx_Oracle to connect from Python to Oracle and the same exact code runs on Windows, Linux, Solaris and soon on AIX. Grig -- http://mail.python.org/mailman/listinfo/python-list

Re: Native ODBC access for python on linux?

2005-07-14 Thread Larry Bates
ODBC is a vanilla interface that puts a layer between the program and the database. In theory, this would allow you to write a program that supports ODBC compliant databases and it would work with any of them. In practice it always seems like this doesn't work as well as everyone had hoped

Re: Native ODBC access for python on linux?

2005-07-14 Thread Grig Gheorghiu
I concur with Larry. I find that by properly abstracting the database connection code in my own class, I can then use any DB-API-compliant Python module to connect to a variety of databases. I use for example cxOracle to connect to Oracle and kinterbasdb to connect to firebird. I haven't tried

Re: Native ODBC access for python on linux?

2005-07-14 Thread Thomas Bartkus
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I'm getting my feet wet with making Python talk to MySQL via ODBC. I started on Windows, and it went smoothly enough due to the ODBC stuff that apparently is native to Python at least on windows (I've been following ch. 13 of Mark

Re: Native ODBC access for python on linux?

2005-07-14 Thread callmebill
Can you tell me what I have to use in order to utilize the MySQL native API? There's some gap (chasm, really) in my knowledge that is keeping me from following that route. If you could provide a small example or a couple names, that would be extremely helpful. Thanks again for your time. Larry

Re: Native ODBC access for python on linux?

2005-07-14 Thread Grig Gheorghiu
1. Download and install MySQL-python from http://sourceforge.net/project/showfiles.php?group_id=22307package_id=15775 2. Try to connect to a MySQL database that you have running. In this example I'm connecting to the bugs database installed with Bugzilla, and I'm connecting as MySQL user root

Re: Native ODBC access for python on linux?

2005-07-14 Thread Mike Meyer
Thomas Bartkus [EMAIL PROTECTED] writes: Although I hear rumors about ODBC drivers on Linux, I confess I don't understand the need. Certainly you can use Python with the MySQLdb module from any Linux machine and query away at the server. As long as the MySQL server accepts your IP/usr/pwd, it