asked on

Script for ODBC

Is there a script to set up DSN ODBC where I can hard code username and password to avoid been prompted each time?

James Murrell

http://www.carlprothman.net/Default.aspx?tabid=89

SOLUTION

Lee W, MVP

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jim P.

If you are using the SQL Server ODBC driver, it doesn't matter if you put the password in DSN, it will not pick it up and use it. It isn't designed that way.

I have VBA module that will create a DSN on the fly, and I know of several other methods of doing it depending on constraints.

Can you give us a little more detail on what you are trying to accomplish?

ohemaa

ASKER

trying to create DSN with username and password embedded in the code so that users do not get prompted for the username and password whenever they try to access an application via the DSN/ODBC

Jim P.

What is your front-end? You will have to do it there.

If it is Access, when you link the tables on the lower right is a check box for Save Password. Turn that on, and that should solve the problem.
Save-ODBC-Password.gif

ohemaa

ASKER

SQl server

Jim P.

SQL server is generally considered the back-end. You have some sort of application that connects to the SQL Server. Depending on how that is designed is whether you can save the password.

The other option is to use Active Directory users and groups with trusted connections.

ohemaa

ASKER

Crystal reports

ASKER CERTIFIED SOLUTION

Jim P.

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ohemaa

ASKER

Leew..thanks for your comments above.

Jim P.

Glad to be of assistance. May all your days get brighter and brighter.