>
>PMFJI,
>
Glad you did...oConnection.provider was returning MSDASQL.1, and I didn't know what that meant. With your string, I get SQLOLEDB.1, it is clear what that means...
It is hard to find get documentation on some of this stuff...in ADO docs it will generally say something to the effect of "it depends on the provider".
>That connection string is for ODBC, and what happens is that ADO uses the default OLEDB provider which is MSDASQL (for ODBC drivers). After opening the connection, check the oConnection.Provider property.
>
>An OLEDB connection string for SQL Server looks something like this:
>"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=testdb;Data Source=orange"
Steve Gibson