By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,281 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

ODBC via Windows authentication

P: n/a
Hello,

We have an internal application that accesses SQL Server 2000 via ODBC.
The connecton is established with user id and password. We recently
received a business request to allow the software to work with Windows
authentication scheme going forward. This implies that users will no
longer have passwords to login to the database. The Windows PC would
take care of the authentication.

Is there a way (perhaps a connection string) to allow ODBC to connect
to the database in this new environment? I would appreciate any tips
or pointers.

Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

<tu*****@yahoo.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
Hello,

We have an internal application that accesses SQL Server 2000 via ODBC.
The connecton is established with user id and password. We recently
received a business request to allow the software to work with Windows
authentication scheme going forward. This implies that users will no
longer have passwords to login to the database. The Windows PC would
take care of the authentication.

Is there a way (perhaps a connection string) to allow ODBC to connect
to the database in this new environment? I would appreciate any tips
or pointers.


There are some sample connection strings for trusted connections here:

http://www.able-consulting.com/MDAC/...erForSQLServer

Simon
Jul 23 '05 #2

P: n/a
I think you can call SQLConnect with an empty user name and password
information.
Also, for using SQLDriverConnect, try to add "Trusted_Connection = yes" into
your connect string.

t> The connecton is established with user id and password. We recently
t> received a business request to allow the software to work with
t> Windows authentication scheme going forward. This implies that users
t> will no longer have passwords to login to the database. The Windows
t> PC would take care of the authentication.

Igor Shekalev, http://www.sqledit.com, SQL editor with ODBC support

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.