Error "Provider not found"

[r_k46211]

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

[vb5prgrmr]

Which mean that the data access layer (the provider or the dll's that provide that service) are not found. You may have to download a MDAC from MS to solve this problem...

http://search.microsoft.com/results.aspx?qsc0=0&q=MDAC&mkt=en-US&FORM=QBME1&l=1

Good Luck

[AndreRet]

It looks like your connection string is faulty. Try the following links to get the correct connection string, and some troubleshoot solutions.

http://www.connectionstrings.com/sql-server-2005
http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx