Setting up ODBC connection through installation or programmatically

[fzamora]

Hi,

I am creating a MS Access front end database with the forms and reports to a SQL Server back end. To set this up I understand that I have to have an ODBC connection set up. I would like to set up the connection with a installation program or programatically. Does anyone know how I can do this. I don't want to have to go each individual machine and set it up manually for a couple of reasons. The main reason is that if the user sets it up he would have to know the password to the SQL Server database. Any help would be appreciated.

Thanks in advance

 

[pbaldy]

Look at setting up a File DSN on the server. You will not have to set up the ODBC link on the user PC's.

 

[namliam]

You can save the password in the queries/linked tables inside the DB. MIND you they are in PLAIN text so anyone can read it, if they know where to look.
Best thing to do, which i took 2 years of fighting for my company to realise , is to setup a readonly functional user with the most limmited rights you can think off. No need to be protective of that (within the company offcourse).

If you create the link using your account or (what i have seen happen) DBA account you will get your self into big trouble if those PW's get out. They mostlikely (in particular the DBA!!!) are more powerfull....

Regards

 

[fzamora]

ODBC Connection

I actually figured it out. but just in case anybody needs to know. I did it by writing to the registry after all an ODBC connection is just some entries in the registry.