ODBC to Oracle (data source name not found)

Bob Gailer bgailer at alum.rpi.edu
Mon Jul 21 08:18:20 EDT 2003


At 04:23 AM 7/21/2003 +0000, Michael J. Moore wrote:

>I have set up an ODBC connection to an oracle database named MIKE on my
>local machine. I have tested this ODBC connection using EXCEL and it works
>fine. The same data source results in ...
>-----------------
>Python 2.2.3 (#42, May 30 2003, 18:12:08) [MSC 32 bit (Intel)] on win32
>Type "help", "copyright", "credits" or "license" for more information.
> >>> import dbi
> >>> import odbc
> >>> d=odbc.odbc('mike/mike/guess')
>Traceback (most recent call last):
>   File "<stdin>", line 1, in ?
>dbi.operation-error: [Microsoft][ODBC Driver Manager] Data source name not
>found and no default driver specified in LOGIN

I had the same problem. I asked the same question. No answer. A search of 
Microsoft extensive online "help" got several links to pages with this error
listed amongst others, but NO explanation!

Bob Gailer
bgailer at alum.rpi.edu
303 442 2625
-------------- next part --------------

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.500 / Virus Database: 298 - Release Date: 7/10/2003


More information about the Python-list mailing list