Solved

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

Posted on 1997-11-04
5
883 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sqlquerystress - To test db performance 8 42
sql server insert 12 30
convert null in sql server 12 34
Sql server, import complete table, using vb.net 9 35
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

777 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