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.