Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
objDBConnection = ObjectOpen('ADODB.Connection') objDBConnection.Open "Provider=sqloledb; Data Source=SRVSQL; Initial Catalog=TestDB; User ID=sa; Password=sa;" Message("", "All Done!") objDBConnection.CloseI'm getting the following error message:
Ole Exception: Data source name not found and no default driver specified.I wrote the same code (with a few minor syntax changes) in vbs and it works great. I love winbatch, what am I missing??? Any help would be greatly appreciated.
objDBConnection.Open("Provider=sqloledb; Data Source=SRVSQL; Initial Catalog=TestDB; User ID=sa; Password=sa;")
Article ID: W17115
File Created: 2007:07:03:14:28:22
Last Updated: 2007:07:03:14:28:22