Jump to content

odbc help


Cybertek
 Share

Recommended Posts

I need some help please,

I am writing a script to install a program that needs a odbc setting with "user dsn" using sql driver. It needs to include name, description, and server name

Is there a way to create this entry using autoit. I feel like this may be impossible. Can anyone please help out

Thanks in advance,

cybertek

Link to comment
Share on other sites

Hope that I understand what you're saying.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MyDb2]
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"DBQ"="C:\\UserData.mdb"
"DriverId"=dword:00000019
"FIL"="MS Access;"
"SafeTransactions"=dword:00000000
"UID"=""

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MyDb2\Engines]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MyDb2\Engines\Jet]
"ImplicitCommitSync"=""
"MaxBufferSize"=dword:00000800
"PageTimeout"=dword:00000005
"Threads"=dword:00000003
"UserCommitSync"="Yes"


####################################
# This one goes into the other key #
####################################


[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"MyDb"="Driver do Microsoft Access (*.mdb)"
"MyDb2"="Driver do Microsoft Access (*.mdb)"

The "MyDb2" is the desired file and located in the directory "C:\\UserData.mdb" so what you need to change is the name of the file+path (the DBQ REG_SZ value) and the name of the new entry "MyDb"="Driver do Microsoft Access (*.mdb)" to "AnotherName"="Driver do Microsoft Access (*.mdb)". Forgive me if I went totally wrong. ;]

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...