MySQL, Python and Odbc 
Author Message
 MySQL, Python and Odbc

Question: How do I setup python to be able to query Mysql using odbc in
Windows..

I have put the files mxOBDC and DateTime into the c:\Python\Lib dir ..
when I run the test script I get the following :

File "C:\python\Pythonwin\pywin\framework\scriptutils.py", line 310, in
RunScript
    exec codeObject in __main__.__dict__
  File "C:\python\Lib\ODBC\Misc\test.py", line 1054, in ?
    rc = main()
  File "C:\python\Lib\ODBC\Misc\test.py", line 1004, in main
    connection = apply(connectapi,connectargs)
OperationalError: ('IM002', 0, '[Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified', 4316)

any help?



Thu, 05 Sep 2002 03:00:00 GMT  
 MySQL, Python and Odbc

Quote:

> Question: How do I setup python to be able to query Mysql using odbc in
> Windows..
> OperationalError: ('IM002', 0, '[Microsoft][ODBC Driver Manager] Data source
> name not found and no default driver specified', 4316)

Taking a guess, it looks like either you haven't installed the Windows
MySQL ODBC driver, or else you haven't set up a system data source
correctly.

I don't know MySQL, but I do believe I have read that there is a Windows
ODBC driver for it.

--
Stand Fast,
    tjg.


Red Hat Certified Engineer            www.exceptionalminds.com
Avalon Technology Group, Inc.                   (503) 246-3630

Quote:
>>>>>>>>>>>>Linux...Because rebooting isn't normal<<<<<<<<<<<<



Thu, 05 Sep 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. VAST, MySQL and ODBC

2. Linux, VW5i.2nc,ODBC MySQL environment string

3. MySQL, ODBC, and C5

4. ODBC and MySQL

5. Memory leak when using database connectivity toolset and ODBC driver for MySQL

6. MySQL -vs- ODBC?

7. Newbie Help -- Python 2.1 - MySQL-python-0.9.0

8. Python, MySQL, and MySQLmodule.c 1.4 - Python Version.

9. python-mySQL module documentation other that python.org?

10. compiling mysql-python for python 2.3 on windows

11. Python/Python Windows/PostgreSQL/ODBC

12. Clarion odbc works with mysql 3 but not with mysql 4. Stuck please help.

 

 
Powered by phpBB® Forum Software