odbc help

[Cybertek]

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

[GrungeRocker]

Try the search:

http://www.autoitscript.com/forum/index.ph...ighlite=%2Bodbc

[Authenticity]

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. ;]