Solved

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

Posted on 1997-11-04
5
870 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?
0
Comment
Question by:catcity
  • 2
  • 2
5 Comments
 
LVL 2

Expert Comment

by:dhodge
Comment Utility
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.
0
 

Author Comment

by:catcity
Comment Utility
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).
0
 
LVL 2

Accepted Solution

by:
Wiz_of_Oz earned 50 total points
Comment Utility
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.
0
 
LVL 2

Expert Comment

by:Wiz_of_Oz
Comment Utility
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.
:)

0
 

Author Comment

by:catcity
Comment Utility
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!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now