Access 2000 Run-Time error 3706

[Donald Pickering]

Am running Access 2000 on Windows 2000 Pro service pack 4.

Trying to connect to a sql server database on a Windows 2000 server running
sql server 2000 service pack 3a.

Public Sub subInserttblScoreSecuritySelection()
Dim cnObject As ADODB.Connection
Dim rsSecSelection As ADODB.Recordset

Set cnObject = New ADODB.Connection

With cnObject
.Provider = "SQLOEDB"
.Properties("Data Source") = "GP6350" <-- failure occurs here with
run-time error 3706.
.Properties("Inital Catalog") = "StockData"
.Properties("Integrated Security") = "SSPI"
.Open
End With

How do I troubleshoot this?
How do I tell what version of Jet I am using?

 

[Dan Artuso]

Hi,
Is that a typo in "SQLOEDB" ?
It should be "SQLOLEDB"

It seems the error is provider not found.
What is "GP6350" ?
Is that the name of your SQL Server?
Try using the IP address instead.