Solved

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

Posted on 1997-11-04
5
877 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
ID: 1089050
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
ID: 1089051
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
ID: 1089052
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
ID: 1089053
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
ID: 1089054
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
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…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

914 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

21 Experts available now in Live!

Get 1:1 Help Now