File DSN help, please.
Hi, I've been using a User or System DSN for my DB connection in tests, so far and it's been working great. I can't create a user DSN on other machines that will be running the tests via T...
Forum Discussion
Thanks Allen,
The solution was to do something like this:
var DSN = "FILEDSN=MyFileDsn.dsn"; // MyFileDsn.dsn resides in my script folder - otherwise include the path to it e.g. =c:\MyFileDsn.dsn
var Qry = ADO["CreateADOQuery"]();
Qry["ConnectionString"] = DSN;
Qry["SQL"] = "select blah blah blah from something";
Qry["Open"]();
But basically, I just had to point the Connection string at the DSN file... should've thought about that in the first place.
The solution was to do something like this:
var DSN = "FILEDSN=MyFileDsn.dsn"; // MyFileDsn.dsn resides in my script folder - otherwise include the path to it e.g. =c:\MyFileDsn.dsn
var Qry = ADO["CreateADOQuery"]();
Qry["ConnectionString"] = DSN;
Qry["SQL"] = "select blah blah blah from something";
Qry["Open"]();
But basically, I just had to point the Connection string at the DSN file... should've thought about that in the first place.
