Unanswered: Error -2147217887 - Data Provider could not be initialized
I was starting to think I was an idiot - but after researching this, I find many people have had this problem, and few have any helpful comments on a solution, so I'll try here.......
The following code runs beautifully on my test environment - however, as soon as I load it onto the network to access the SQL server, I get the blasted - error 2147217887 - "Data Provider could not be initialized"
I'm dying here - does anyone know how to resolve this problem?????
Set cn = New ADODB.Connection
.Provider = "Microsoft.Access.OLEDB.10.0"
.Properties("Data Provider").Value = "SQLOLEDB"
.Properties("Data Source").Value = "SOS-1"
.Properties("Integrated Security").Value = "SSPI"
.Properties("Initial Catalog").Value = "TIMS"
'Create an instance of the ADO Recordset class, and
'set its properties
Set rs = New ADODB.Recordset
Set .ActiveConnection = cn
.Source = RecSourceFloater
.LockType = adLockOptimistic
.CursorType = adOpenKeyset
'Set the form's Recordset property to the ADO recordset
Set WeekDay.Form.Recordset = rs