MS SQL Server ODBC - Error Creating DSN using odbcconf.exe for SQL Server

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Error Creating DSN using odbcconf.exe for SQL Server

Gurpreet S Gill

2006-10-24, 6:40 pm

hi there

i want to create a DSN using command line arguments,with Trusted
connection=no, Login name= sa password=*******

i try creating like this

C:\>odbcconf.exe /a {CONFIGSYSDSN "SQL Server"
" DSN=blabla|Descripti
on=blablubb|SERVER=v
snet1|Trusted_Connec
tion=no
|Database=dm"}

this work fine, but when i specify the login id & password as

C:\>odbcconf.exe /a {CONFIGSYSDSN "SQL Server"
" DSN=blabla|Descripti
on=blablubb|SERVER=v
snet1|Trusted_Connec
tion=no|loginid=sa|p
assword=sysadm|Datab
ase=dm"}

this throws an error as

CONFIGSYSDSN: Unable to create a data source for the 'SQL Server' Driver:
Invalid keyword-value pair with error code :2147467259

I too try the

loginID, login id, login , user, userid, uid

Password, pwd

and many more...

all these throws same error.

Please help me.

Regards,

Thnaks.

Gurpreet S. Gill

Sponsored Links