I get Error 3001 "The Application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. The microsoft solution does not work for me. My Code is
Set adoRS = New ADODB.Recordset
adoRS.Open "SELECT * FROM table WHERE Name = "JOHN",adoConnectToSQL,adopendynamic,adlockoptimistic,adcmdText
It bombs on the open line. My Ado connection object is being set in a public function called ConnectToSQL. The recordset object is being set and opened in another function. Any ideas? If I establish the connection in the same function as the recordset it works fine. But I don't want to have to establish a connection every time I create a recordset. I want to be able to use one connection throughout the project.