Help with ODBC

[dufran3]

I am trying to automagically create a ODBC connection to a SQL Server. Anyone know of any fancy good ways to do this? I know there are some registry entries, but I was hoping maybe there was a way to do it using API or something. Thx for the help!

[AutoChris]

I am trying to automagically create a ODBC connection to a SQL Server. Anyone know of any fancy good ways to do this? I know there are some registry entries, but I was hoping maybe there was a way to do it using API or something. Thx for the help!

To answer your question, since no one else has, the best way that I know of to create an ODBC connection is through the registry.

System DSN:

RegWrite("HKCU\Software\ODBC\ODBC.INI\(DSN name)", "Database", "REG_SZ", "(database name)")

RegWrite("HKCU\Software\ODBC\ODBC.INI\(DSN name)", "Driver", "REG_SZ", @SystemDir & "\sqlsrv32.dll")

RegWrite("HKCU\Software\ODBC\ODBC.INI\(DSN name)", "LastUser", "REG_SZ", "(user name)")

RegWrite("HKCU\Software\ODBC\ODBC.INI\(DSN name)", "Server", "REG_SZ", "(server name)")

To list your ODBC connection in the ODBC Administrator:

RegWrite("HKCU\Software\ODBC\ODBC.INI\ODBC Data Sources", "(DSN name)", "REG_SZ", "SQL Server")

[dufran3]

Question, the "Last User" key, or the username key, my SQL server also requires a password. Where do I enter that in at?

[LOULOU]

Question, the "Last User" key, or the username key, my SQL server also requires a password. Where do I enter that in at?

The reply is here

http://www.autoitscript.com/forum/index.php?showtopic=20814

[ame1011]

If its a mysql connection that you're trying to make, take a look at: this

if its another ODBC connection that u need, that may also help you out, just take a look at the code and make the proper substitutions.

[dufran3]

I appreciate the help, I tried using that, however it isn't quite what I am looking for. It seems as those just temporarily create a connection, I need to actually add a system DSN on the local computer. I appreciate your help guys!