| Author |
script to create uniform odbc dsn
|
|
|
| Hi all,
I need to set up a list of odbc connections to a back end database server
for a group of colleagues. I would like to write a short script where they
can run it themselves and set them up. Can you share some thoughts and code?
Thanks in advance.
Ben
--
| |
| Ken Halter 2005-12-13, 6:56 pm |
| "Ben" <Ben@discussions.microsoft.com> wrote in message
news:4C334882-A341-4F6B-B7F0-71FF35011160@microsoft.com...
> Hi all,
>
> I need to set up a list of odbc connections to a back end database server
> for a group of colleagues. I would like to write a short script where
> they
> can run it themselves and set them up. Can you share some thoughts and
> code?
> Thanks in advance.
>
> Ben
| |
| Ken Halter 2005-12-13, 6:56 pm |
| "Ben" <Ben@discussions.microsoft.com> wrote in message
news:4C334882-A341-4F6B-B7F0-71FF35011160@microsoft.com...
> Hi all,
>
> I need to set up a list of odbc connections to a back end database server
> for a group of colleagues. I would like to write a short script where
> they
> can run it themselves and set them up. Can you share some thoughts and
> code?
> Thanks in advance.
>
> Ben
oops (darned ctrl-enter!) anyway.... this may help.
Auto-Create ODBC settings on Windows 2000
http://groups.google.com.my/group/c...ee41906b2d6a046
If this is correct, you can create the ones you need locally, take a
snapshot of the appropriate registry "tree" and import that to everyone's
pc.
--
Ken Halter - MS-MVP-VB - Please keep all discussions in the groups..
DLL Hell problems? Try ComGuard - http://www.vbsight.com/ComGuard.htm
Freeware 4 color Gradient Frame? http://www.vbsight.com/GradFrameCTL.htm
| |
|
| Thanks Ken, that's what I need. Much appreciated.
Ben
--
"Ken Halter" wrote:
> "Ben" <Ben@discussions.microsoft.com> wrote in message
> news:4C334882-A341-4F6B-B7F0-71FF35011160@microsoft.com...
>
> oops (darned ctrl-enter!) anyway.... this may help.
>
> Auto-Create ODBC settings on Windows 2000
> http://groups.google.com.my/group/c...ee41906b2d6a046
>
> If this is correct, you can create the ones you need locally, take a
> snapshot of the appropriate registry "tree" and import that to everyone's
> pc.
>
> --
> Ken Halter - MS-MVP-VB - Please keep all discussions in the groups..
> DLL Hell problems? Try ComGuard - http://www.vbsight.com/ComGuard.htm
> Freeware 4 color Gradient Frame? http://www.vbsight.com/GradFrameCTL.htm
>
>
>
| |
| Jeff Johnson [MVP: VB] 2005-12-14, 3:55 am |
|
"Ben" <Ben@discussions.microsoft.com> wrote in message
news:4C334882-A341-4F6B-B7F0-71FF35011160@microsoft.com...
> I need to set up a list of odbc connections to a back end database server
> for a group of colleagues. I would like to write a short script where
> they
> can run it themselves and set them up. Can you share some thoughts and
> code?
> Thanks in advance.
While there may be times that DSNs are absolutely necessary, I highly
recommend using DSN-less connections whenever possible.
|
|
|
|