Networks

Ask something
Question Locked

ODBC Connection

0 helpful
11 replies

by charvell

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way to set up an SQL Server ODBC connection to automatically pass a specified login? We create separate SQL usernames that are not the network login used on the PC. Using XP SP2.

11 replies

by charvell

unfortunately a lot of that is more technical than I can get with the application I'm using. I honestly have no idea how I would pass a connection string to the application (Microsoft FRx 6.7 SP10) or if it would even use one or if it requires an actual ODBC connection.

by pshiflet-24

Without access to the connection string you can't force UID or PW from within it. System DSNs don't store UID or PW either, since they are accessible by all users of the PC (if I remember correctly). File DSNs, however, seem to be able to do just that. There are reasons that file DSNs aren't always the best solution, though (plain text...), so consider that. I hope that helps.

by shellbot

Control panel - odbc connections -
either system or user, and use a SQL user account (which you've created in SQL Server).

that stores the un & pw for ya

by charvell

I don't have an ODBC Connections option in Control panel, I have to go to Administrative Tools - Data Sources (ODBC) which I'm going to assume is the same thing.

I've set up a System DSN to the SQL server with the correct database specified, however, regardless of which login option I chose (Windows NT authentication, or SQL Server Authentication using login ID and password entered by the user) it prompts me for a un & pw for the database connect when I launch my application that uses the connection.

by shellbot

Ya, same thing..

ok.. so you created a new sql data source.
you choose sql auth, and input the un & pw?

Have you ensured that the SQL user has been created in SQL with the correct permissions?
I've just done a test one now, but using SQL 2008...so might be a few different things on it, compared to the older versions.
but I've given the user a "public" server role, mapped the user to the AdventureWorks database, and given it datareader and public permission in the mapping. In the status I've granted it permission to connect to the database and enabled the login.(obviously permissions are up to you and what the app needs to do..you will likely need a few more if its writing to the DB)

by charvell

I've recreated the issue on my machine and have been trying to use the default SQL admin login. We're running SQL Server 2005.

by shellbot

"We create separate SQL usernames that are not the network login used on the PC"

How is this application accessed? Is is looking for an individual users specific log in, or a system login?

As in, have you created 10 different SQL users, or 1 system user?

by charvell

The program is FRx 6.7 for what its worth. We have 1 login that 3 users use. I've reproduced the issue on my machine using a different login that is specific to me only, but still haven't been able to find a way to have that login passed without having to enter it when launching the program.

by shellbot

ya...

try looking up file dsn
this is where ya create a text file (with .dsn) extension, and save it on the local machine and that stores the password ect...

This discussion is closed to new replies.