Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
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;
|Running sum query||6||32|
|How can i get data when i use where clause with group by?||3||21|
SQL 2012 update fails repeatedly : the UPdate is SQLServer2012-KB3194721-x6
|SQL Field Length for Email Address||3||17|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!