Home » Infrastructure » Windows » odbc dsn
odbc dsn [message #268694] Wed, 19 September 2007 07:07 Go to next message
gstijl
Messages: 3
Registered: September 2007
Junior Member
Hi,

I have a text file with 700 odbcstrings.
Anyone who can help me to write a script to create all system dsn odbc connections?

I you can give my an example it would be great!

kind regards,

Gerry

[Updated on: Wed, 19 September 2007 07:08]

Report message to a moderator

Re: odbc dsn [message #268724 is a reply to message #268694] Wed, 19 September 2007 08:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you will likely get more answers in a Windows forum site.
This is an Oracle one.

Regards
Michel
Re: odbc dsn [message #269286 is a reply to message #268724] Fri, 21 September 2007 08:27 Go to previous message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

Just few guides:
1. You have to read registry first. In the registry you have to find out the Oracle ODBC Driver in the path SOFTWARE\ODBC\ODBCINST.INI\Oracle ODBC Driver.
2. Now you have to add values into the registry in ODBC.INI which is located on SOFTWARE\ODBC\ODBC.INI.

Now build the script such that it can do the both operations.

Cheers
Soumen
Previous Topic: installation on window
Next Topic: Creating Log of Batch Jobs
Goto Forum:
  


Current Time: Tue Apr 16 18:12:33 CDT 2024