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
[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_
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
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
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
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
[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
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
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
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
10 matches
Mail list logo