Question

Locked

ODBC Connection

By Charvell ·
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.

This conversation is currently closed to new comments.

11 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Re: connections

by christianshiflet In reply to ODBC Connection

Check out http://www.connectionstrings.com/. You should be able to setup a connection string with whatever user name and password combination you desire for just about any database around. I hope that helps.

Collapse -

Lots of Information but

by Charvell In reply to Re: connections

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.

Collapse -

Re: DSN

by christianshiflet In reply to Lots of Information but

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.

Collapse -

Set up the connection on the pc

by Shellbot In reply to ODBC Connection

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

Collapse -

Re: Connections

by Charvell In reply to Set up the connection on ...

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.

Collapse -

Hmm

by Shellbot In reply to Re: Connections

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)

Collapse -

Re: Hmmm

by Charvell In reply to Hmm

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.

Collapse -

As your first post:

by Shellbot In reply to Re: Hmmm

"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?

Collapse -

1 User

by Charvell In reply to As your first post:

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.

Collapse -

ok

by Shellbot In reply to 1 User

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...

Back to Networks Forum
11 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums