>
>That's because OLEDB doesn't load the ODBC manager .. even when going through and ODBC driver. The ODBC manager is the slowest part of ODBC.
So, is the ODBC driver still involved to some degree, even when using OLEDB? I've had a few error messages with 'ODBC' in them, and was concerned that I was not actually using OLEDB like I am intending to. IOW, I need to *know* that I am actually using OLEDB. Here is how I am connecting...
oConnection = CREATEOBJECT("ADODB.Connection")
lcConnString = "DRIVER={SQL Server};" + ;
"SERVER=orange;" + ;
"DATABASE=testdb;UID=sa;PWD="
oConnection.open(lcConnString)
rutoh! Now you know the password!! :)
Steve Gibson