Jump to content

Help with ODBC batch script


Recommended Posts

I would like to create a driver for SQL so its listed under ODBC (System DSN). So far i have this code:

@ECHO OFF 
REM Update...
odbcconf.exe /a {CONFIGSYSDSN "SQL Server" "DSN=Name|Description=Description to add|SERVER=production\in|Network=DBMSSOCN|Trusted_Connection=Yes|Database=Inventory_control"}
REM pause
@CLS
@EXIT

This works but i cant figure out how to add a username and password which is listed in our Sql database - Is this possible, if yes is there anyway to encrypt it?

Thanks

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
  • Recently Browsing   0 members

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