Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.
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;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.