From: davem1957@... (David Moore)
Date: 2002-12-03T18:11:44+09:00
Subject: Re: DSN-less connection (Re: exerb)

"Shannon Fang" <xrfang@hotmail.com> wrote in message news:<F145R8lPefPqNwHl5Rt0000d46c@hotmail.com>...
> Thanks David.
> 
> I will test it soon. However, here's another question: I remember when I 
> used ADO in ASP web application, I can use ADODB.Connection without using a 
> DSN. In another word, ADO is completely independent from ODBC, and it should 
> be at a lower level. If I didn't misunderstand, the CONNSTR in your sample 
> code should be an ADO connection string without the need to setup a DSN in 
> ODBC manager, right?
 
Correct. I just happened to be using a DSN in that sample. Here is a
useful resource for the type of cinnection strings you can use:

http://www.able-consulting.com/ADO_Conn.htm

> The win32ole module is built into the interpretor so that we don't need to 
> use a .so or .dll?

I'm not sure why Win32Ole works when ODBC does not. I just remember
being very grateful when I found that it did.
 
> Thanks,
> Shannon
>