SQL ODBC Batch file question

Any help on this would be appreciated!!!

It should be something like this:

cd C:\WINDOWS\system32
"odbcconf.exe" /a {CONFIGSYSDSN "SQL Server" "DSN=tkcsdb|Description=tkcsdb|SERVER=vsapp9|Network=MAHC|Trusted_Connection=No|LastUser=sa|Database=tkcsdb"}

pause
@CLS
@EXIT

Select allOpen in new window

I usually build a file and load it via regedit:

Windows Registry Editor Version 5.00 
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
    "ExampleDSN"="SQL Server"  
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ExampleDSN]
    "Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
    "Description"="To give details"
    "Server"="ServerName"
    "QuotedId"="No"
    "AnsiNPW"="No"
    "Database"="AdventureWorks"
    "LastUser"="sa"
    "AutoTranslate"="No"

Select allOpen in new window

You can read more about it here: Creating DSNs for SQL Server: In depth on how to make one.

THanks!  Is there a spot where I have to put a password in though or no?

You can't save the password in the ODBC call. That has to be handled by your application. As an example if your were to link from an MS Access db, there is a hidden table called MSysobjects. The Connect column would look something like this:
 

DSN=TCL;UID=AppMGR;PWD=password;APP=Microsoft Office XP;AutoTranslate=No;QuotedId=No;AnsiNPW=No

Select allOpen in new window

In reference to : 37354575
You could also try adding the key:
"PWD"="ThePassword"

Let me know if it works.

So you mean something like this?

cd C:\WINDOWS\system32
"odbcconf.exe" /a {CONFIGSYSDSN "SQL Server" "DSN=tkcsdb|Description=tkcsdb|SERVER=vsapp9|Network=MAHC|Trusted_Connection=No|LastUser=sa|PWD=password|Database=tkcsdb"}

pause
@CLS
@EXIT

Select allOpen in new window

ReneGe,

I tried that in the past. The SQL Server and SQL Native Client drivers are designed to deliberately to ignore it. Some other drivers can and do support that withe either plain text or encrypted passwords.

Would you want every person that had access to the registry to be able to see your plain text password?

damn!  I thought that original code was going to work...turns out im getting this error....any ideas?

I just realised it was about "SQL Server" not "MySQL".

Sorry for that ;(