0

Hi,

I have a computer that has Win-2003 and SQL Server 2005 Installed.

I checked my client and server both are giving the response to each other using ping their address.

I created a string as:

----------------------------------------------------

Public conn As New ADODB.Connection

Public rs As New ADODB.Recordset

Sub main()

Set conn = New ADODB.Connection

conn.ConnectionString = "Provider=SQLNCLI;Server=PUNSEZ178073d;Database=test;Uid=sa;Pwd=Infosys123;"

conn.Open

conn.close

end sub

----------------------------------------------------

Above string is working fine at Server machine but when i am running the same script on client machine i am getting error "Provider not found".

Please help

3
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by AndreRet
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.