RE: Create System DSN

From: JDTerrazas (JDTerrazas_at_discussions.microsoft.com)
Date: 09/07/04


Date: Tue, 7 Sep 2004 09:03:11 -0700

Hi again,

The file ODBCCONF.EXE can create a DSN from command line but I can't create
a DSN with correct parameters, an example is:

"ODBCCONFIG /a {configdsn "SQL Server DSN=cursql SERVER=MXJ41102V2 UID=sa}

This create the DSN but the parameters are the same as the Server name is
the same of the DSN and the user is the Admin user.

Can anybody help me with Information or how can I pass the parameters
correctly.

Thnx.

"JDTerrazas" wrote:

> Hi,
>
> Is there a way to create a DSN directly from CMD window, I mean with command?
>
> I'm trying to create a BAt file to do this?
>
> A apreciate any help.
>
> Thnx.



Relevant Pages

  • Re: Create System DSN
    ... > The file ODBCCONF.EXE can create a DSN from command line but I can't ... > a DSN with correct parameters, ... >> Thnx. ...
    (microsoft.public.data.odbc)
  • Re: IOF QUESTION
    ... Select your output and then enter SD on the command line. ... It will open a panel you can override size and dsn name. ... send email to listserv@xxxxxxxxxxx with the message: GET IBM-MAIN INFO ... Search the archives at http://bama.ua.edu/archives/ibm-main.html ...
    (bit.listserv.ibm-main)
  • Re: Batch TMP RECFM(VB) Input
    ... E 'DSN' DA ... columns 73 to 80 of a fixed blocked data set ... The TSO command parser will ignore these columns, so unnumbering the data set is irrelevant. ...
    (bit.listserv.ibm-main)
  • Re: IOF QUESTION
    ... Select your output and then enter SD on the command line. ... It will open a panel you can override size and dsn name. ... send email to listserv@xxxxxxxxxxx with the message: GET IBM-MAIN INFO ... Search the archives at http://bama.ua.edu/archives/ibm-main.html ...
    (bit.listserv.ibm-main)
  • DSN in code
    ... Could somebody explain how to create DSN using ActiveX ... Prev by Date: ...
    (comp.soft-sys.matlab)