ODBC DSN Connection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have two pass-through queries in my database application. This
application is used only by my department. In order to make the queries
function, I went to each user's pc and set up the two ODBC Connections.

We now want to enable users outside our department to use the application.
I was about to go around to each person's pc and set up the two ODBC
Connections, when our IT people said they thought there should be a way to
enable the connections without having to go to each person's pc.

They want us to try to do this because of the connections will not be a part
of the ghosting of the pc's, and also because the pc's will get upgraded this
year. They feel we shouldn't have to go around to each person's pc each time
there's a change like this.

Can I enable the connections without physically setting them up on each
user's pc?

Thanks,
 
Rosemary said:
Hi,

I have two pass-through queries in my database application. This
application is used only by my department. In order to make the queries
function, I went to each user's pc and set up the two ODBC Connections.

We now want to enable users outside our department to use the application.
I was about to go around to each person's pc and set up the two ODBC
Connections, when our IT people said they thought there should be a way to
enable the connections without having to go to each person's pc.

They want us to try to do this because of the connections will not be a part
of the ghosting of the pc's, and also because the pc's will get upgraded this
year. They feel we shouldn't have to go around to each person's pc each time
there's a change like this.

Can I enable the connections without physically setting them up on each
user's pc?

Thanks,
Click to expand...

You can create ODBC DSN's programmatically (e.g. in some start up code for
your database) using the RegisterDatabase method.
 
....and a third way of doing it. An ODBC connection is just a bunch of
registry settings... take a look at HKLM\Software\ODBC\ODCB.INI

I have a login script utility that allows me to set registry entries, but
you could also do it by importing a .reg file.
 
No. It's the location of the ODBC settings in the registry. You can get to
see it by Start, Run and then either regedit or regedt32. HKLM is shorthand
for HKey_Local_Machine. There's a little introduction here
http://www.annoyances.org/exec/show/registry

Having said that, the registry is something that needs to be taken care of.
Editing it incorrectly can be disastrous. Maybe you could look at my
suggestion with one of your IT people, but don't edit it unless you are
confident in what you're doing.
 
Back
Top