Again: ODBC / Win98 -> crash

[musingattheruins at my-deja.com]

found it... i was tripped up by a python-com-ism.  The 'O' in
'ADODB.Connection.Open' command i was running was a small 'o'...

import win32com.client
conn = win32com.client.Dispatch('ADODB.Connection')
conn.Open(connectstring)
# was calling... conn.open(connectstring)

msft ado returned a 80004005 error... (-2147467259, 'Unspecified
error', (0, 'Microsoft OLE DB Provider for ODBC Drivers', '[Microsoft]
[ODBC Driver Manager] Data source name not found and no default driver
specified', None, 0, -2147467259), None)

this is misleading; the dsn _does_ exist... not sure what was actually
called through com since 'open' was the wrong function name.

aside from my own stupidity i have had no other problems with MDAC 2.5.

bill :-/

> i have installed the most recent mdac 2.5 and now cannot connect to
any
> DSNs with ADO!!! and cannot make DSN-less connections with ADO!!!
>
>   tried rolling back to 2.1 (nope... component checker reports v 2.5)
> + re-install 2.5
> + re-install python 1.5.2
> + re-install python win32 all
> + try again
> --------------------------------
>  NFG
>
> no solution yet... _if_ i find one i will post it.
>
> bill :-(


Sent via Deja.com http://www.deja.com/
Before you buy.