From: Chris Morris Date: 2002-12-02T13:15:34+09:00 Subject: Re: DSN-less connection (Re: exerb) > 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? Some general info: Both ADO and ODBC can have connections created with or without using a DSN. IIRC, ADO actually rides on top of ODBC, simply providing a COM interface whereas ODBC did not have one. Chris