| || |
Trouble connecting to DB with WR
I'm unable to connect to a database using WR.
I'm using db_connect("MyConn", "DSN=MyDSN, UID=winrunner, Pwd=winrunner", 10);
and I'm getting error code -10161 returned, which is "The connection to the database failed."
I can connect via MS Access, and the connection test passes in the data sources setup, so the only other thing I can see that may be wrong is the way I supply the connection string. Is the way I'm doing it correct, or is there another way?
Re: Trouble connecting to DB with WR
I've answered my own question. I needed to use semi-colons instead of commas in the connection string.