This code bombs out on the line that starts: SET rs =
strDriver = "SQL Server Native Client 11.0" cnn = "ODBC;DRIVER=" & strDriver & ";SERVER=" & ServerName _ & ";Trusted_Connection=Yes;APP=Microsoft Office 2003;WSID=" & ServerName _ & ";DATABASE=" & DBName & "; " Set db = CurrentDb Set qdf = db.CreateQueryDef("") qdf.Connect = cnn qdf.ReturnsRecords = True qdf.SQL = "SELECT top 1 dbo.SomeTableName. * from dbo.SomeTableName" Set rs = qdf.OpenRecordset() rs.Close
and create a new pass-through query with identical SQL string, it returns the 1 record I'm looking for, so the connection is valid, but I keep getting this error message.
ODBC;DRIVER=SQL Server Native Client 11.0;SERVER=ServerName;Trusted_Connection=Yes;APP=Microsoft Office 2003;WSID=ServerName;DATABASE=dbName;
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.