Member Avatar for 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

  • 3 Contributors
  • 2 Replies
  • 126 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by AndreRet
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.