Try
.ConnectionString = "Provider=SQLOLEDB.1;" + ;
"Persist_Security_Info=False;" + ;
"Data Source=TESTSERVER"
>Thanks Sergey and Terry for all your help. I appreciate it very much.
>
> I did as you said but I am having the following error message when I am trying to do OConnection.Open() or OConnection.Open( ,"MyuserId","mypassword")
>
>Error Message: OLE Idispatch exception code 0 from Microsoft OLE DB service components: Format of the initialization string does not conform to the OLE DB specification.
>
>
>Thank you once again,
>Kumar.
--sb--