In MS SQL Server - Console Root\Microsoft SQL Servers\SQL Server Group\(local)(Windows NT) What is data source? I only put there LocalServer since it is in System DSN of ODBC and I'm using local. Some sites are using SQLOLEDB and others use MSDASQL. What provider should be used? I am using MS SQL Server 2000.
MyRecSet.Open sqlStr, M圜onnObj, adOpenKeyset M圜onnObj.ConnectionString = "Provider = MSDASQL " & _ Dim M圜onnObj As ADODB.Connection 'ADODB Connection Objectĭim myRecSet As New ADODB.Recordset 'Recordset Objectĭim sqlStr As String ' String variable to store sql command
0 kommentar(er)
