Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 DSN problem

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2009-01-29 : 16:22:15
I used dsn file as below to link Access to a SQL server.
Everytime need to input password, why? How to void it?

[ODBC]
DRIVER=SQL Server
UID=sa
PWD=holiday
DATABASE=Order
WSID=ASPFUN
APP=Microsoft Data Access Components
SERVER=111.222.333.444

Rajesh Jonnalagadda
Starting Member

45 Posts

Posted - 2009-01-30 : 04:51:47
Try using Windows NT authentication

Rajesh Jonnalagadda
[url="http://www.ggktech.com
"]GGK TECH[/url]
Go to Top of Page
   

- Advertisement -