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;"



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