Post reply

odbcconf

  • March 9, 2004 at 8:54 am

    #76138

    I am trying to run this odbcconfig in a command file

    odbcconf.exe CONFIGSYSDSN "SQL Server" "DSN=%1|Description=%1|Server=%2|Trusted_Connection=No|UID=%4|PWD=%5|Database=%3"

     

    I get a message 'Unable to create datasouce for SQL Server Invalid Keyword-value pairs'

    I am trying to use SQL Authentication.

    Any idea what's wrong?

     

  • March 9, 2004 at 10:11 am

    #498007

    I'm guessing the .cmd isn't getting the substitutions into the parameter of the odbcconf file. Since they are quoted, not sure if the parser correctly substitues these.

  • March 9, 2004 at 11:04 am

    #498025

    I've done a ton of digging on google and found out that you cannot put passwords in, making it pretty useless to replicate 10 web servers with all the same odbc connections.

     

  • April 2, 2004 at 8:14 am

    #501622

    Is there a way to use this in a vbsript shell.. the problem is that i have to use it with a "RUNSAS" script so i can admin rights w/o have to enter in the password ( so it can run on auto durning user login&nbsp . The problem i am having is w/ the pipe's ( | ), they are causing the shell to try and run "Discription" as a program. Is there a way to get around this? I tired escaping them w/ "" but that did not work.

     

    -- Thx, Sal

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply