This download #
9840 can help you look at connection string issues and also reports any COM errors. You just have to enter data source and password. It will return the entire connection after a successful connect.
Sergey might string in with some setting info.
>Hi All,
> Basically I need to create a Web service on my machine. So I ‘ve created a ADO interface to connect to my SQL Server for accessing the tables. I have the following problem when I open the database using oConnection.Open. Error Message: OLE Idispatch exception code 0 from Microsoft OLE DB Provider for SQLServer:[DBNETLIB][ConnectionOpen(Connect().]Sql Server does not exist or access denied.
>
>I don’t know what is the problem? May be I am having security rights?
>Please help.
>
>Thanks,
>
>Code:
>
> LOCAL oConnection as Variant
> LOCAL loCommand as Variant
> oConnection = CREATEOBJECT("ADODB.connection")
> WITH oConnection
> .Provider = "SQLOLEDB.1"
> .ConnectionString = "Persist Security Info=False;
> Data Source=TESTSERVER\USHM;
> Auto Translate=True;Use Encryption for Data=False;
> Tag with column collation when possible=False"
> ENDWITH
> oConnection.open("USHM"," "," ")
Imagination is more important than knowledge