ADO/ODBC/ASP/Python error

Mon Jan 7 21:50:52 EST 2002

"Jason R. Coombs" <jaraconospam at jaraco.com> wrote in message news:<a1dal3$e4t$1 at sass2141.sandia.gov>...
>>>>>>>>>>>>>>>snip
> > <HTML><HEAD><TITLE>enter sample</TITLE></HEAD><BODY>
> <%@ language=Python %>
> <%
> from win32com import client
> 
> conn = client.Dispatch("ADODB.Connection")
> conn.open ("Provider=MSDASQL;DSN=EnvMon")
> %>
> 
> Error Type: Python ActiveX Scripting Engine (0x80020009)
> Traceback (innermost last): File "<Script Block >", line 4, in ? conn.open
> ("Provider=MSDASQL;DSN=EnvMon") File "C:\Program
> Files\Python\win32com\client\dynamic.py", line 432, in __getattr__ raise
> pythoncom.com_error, details COM Error: [Microsoft][ODBC Driver Manager]
> Data source name not found and no default driver specified
>>>>>>>>>> snip
> Jason

Error message sugests that the connection string is not in correct format
See http://www.e-coli.net/pyado.html for a nice introduction to ADO and Python

waldekO