| || |
db connection string
I am trying to connect to a database in one of my scripts. I am able to connect and execute the scripts when I have NT authentication. However, I am having trouble connecting to the db when I do not have network authentication. I am using the following connection string - "DSN=DBNAME;UID=sa;PWD=password".
When I setup the system dsn I am able to connect to the db with the above criteria. It is just not working when I try and run the scripts without network authentication.
Re: db connection string
i think, its important that you must have access rights on the DB when u not have NT authentication. So set ur (user name on LAN) access rights on DB manually and then try ur script.
Jawad Rashid: email@example.com
EvEry pErson is a nEw door to a diffErEnt world