We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

ODBC connection string for MS-SQL Server 6.5, mixed security

catcity
catcity asked
on
Medium Priority
927 Views
Last Modified: 2008-02-07
I need to link an Access front end to an MS-SQL Server 6.5 database.  The system is configured using "mixed" security, ie, the user's ID and password on the Win/NT 3.51 workstation should be used by SQL Server to authenticate the user.

How do I set the ODBC connection string to do this from Access rather than asking for a user ID and password as happens with the default "ODBC;" connection string?
Comment
Watch Question

Commented:
Try connecting with a string such as

"ODBC;DSN=odbcname;UID=userid;PWD=pwd"

Substituting odbcname, userid and pwd for the relevant odbc name, user id and the password respectively.

This will make the connection without prompting the user for password and id.

Author

Commented:
That tells me how to do it using standard security techniques, dhodge.  I need to use MIXED security, ie, passing through a trusted connection as opposed to a specific login to SQL server.

The standard security, ie passing a UID & password, is well documented; I need to know how to use a trusted connection for mixed security.

If you know how to do this, please comment appropriately & I'll accept your answer, or if not I'll have to reject it (which I'd rather not do).
if u are using the 2.65.* ODBC u can configure a new ODBC connection and check the flag "trusted connection", done this your connection string will be just the ODBC connection name.
i.e.: if u configured a connection named "ODBC_NEW" your connection string will be just "ODBC_NEW"....
let me know if this help u in solvign your prob.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
sorry, in the answer i forgot to mention ODBC 3.*...
if u r using this ODBC engine, u will be prompted during the connection definition to select wich type of connection (trusted/UID,passwd) u will use...
tell me more about your odbc engine if the answer is not right to solve the prob.
:)

Author

Commented:
Thx for the proposed answer, Wiz of Oz.  I don't know what ODBC version I'm using, will find out on Monday and let you know.  Cya  then!
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.