Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Automate ODBC DSN Setup

 
   Database Help (Home) -> Visual Basic -> ODBC RSS
Next:  how to error code from DB2 communication area!  
Author Message
JP

External


Since: Aug 13, 2005
Posts: 1



(Msg. 1) Posted: Sat Aug 13, 2005 7:10 pm
Post subject: Automate ODBC DSN Setup
Archived from groups: microsoft>public>vb>database>odbc (more info?)

I have been thinking of using VBscript to automate the set up of the ODBC
DSN entries. There are some discussions on the Internet that I can find.
Unfortunately, none of them gives me any hints on how I can store the
username (such as sa) and password for the connection.

I know I can use VBscript to modify the registry or simply importing the
..REG files which I exported from a manually created DSN entry. Here is the
key to be modified:

HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources\

Although I can manually create a new DSN and stored the password (through
Control Panel or by running ODBCAD32), I can't find the password in the
registy. Anyone has a good suggestion?

Joe

 >> Stay informed about: Automate ODBC DSN Setup 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
The whole ODBC idea - To date my database stuff is with access databases, and I have no real appreciation with using ODBC. My VB6 application: Developing code to be run on a Win2000 machine that needs to read/write certain records in a Foxpro database. However the ..

LDAP query from ODBC? - I'm trying to build a query to pull some information from my LDAP based on a user ID. Dim conLDAP As ADODB.Connection Dim strSQL As String Dim strLDAPConn As String Dim rsUser As ADODB.Recordset Set conLDAP = New ADODB.Connection ...

ODBC Access reference material - Hi there, I was wondering if there was some kind of online reference as the the syntax used for a Microsoft ODBC Access driver's SQL statements. I'm converting a web site over to another server and I'm having syntax issues as I've just switched....

ODBC CONNECTION FROM COMMAND LINE - I am trying to get an ODBC connection created from a commandline, I have created the ODBC connection, exported the registry key, and have tried doing regedit /s "regkey", problem is after I do that it never shows us in the ODBC manager, it sh...

Cursor Error w/ ODBC SQL2000 - My office inherited a legacy VB6 program that connects via a MSRDC to a SQL2000 server. The original ODBC connection pointed to a legacy Win2000 Adv Server w/ SQL2k, we have upgraded a test server Win2k3 w/ the same SQL2k. The previous server didn't..
   Database Help (Home) -> Visual Basic -> ODBC All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]