SQL 2000 Server connection

[JonyBravo]

I'm using the follwoing part of code to connect to an VB6 application to a sql 2000 server:

Sconn=”Provider=SQLOLEDB.1;Trusted Connection = True; Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=PARS;Data Source=10.100.66.118"

conn.open sconn

The problem is whe I run the application I get an error pointing to (conn.open sconn) saying the following:

Multiple step OLE DB operation general errors. Check each OLE DB Status value, if available no work was done.

Does anyone can help me and tel me what I'm doing wrong?

Thansk in advance

 

[pbaldy]

That doesn't quite look right to me. Check this:

http://www.connectionstrings.com/?carrier=sqlserver