Re: Create System DSN

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Brannon Jones (brannonjNOSPAM_at_gmail.com)
Date: 09/14/04


Date: Mon, 13 Sep 2004 17:42:29 -0700

Try looking at the odbcconf.rsp, redist.rsp or sqlclnt.rsp files in the
System32 directory for examples of how to use ConfigDSN.

ODBCCONF.EXE is not supported by Microsoft. It's used during setup to
create the initial DSNs and configure ODBC. It isn't meant to be used
directly by users. If it works, great, if it doesn't, or if it isn't
documented for some reason, you're pretty much out of luck.

Of course, ODBCCONF.EXE just uses public ODBC APIs to create DSNs, so if you
can't get the utility to work, you can always write it yourself.

Brannon

"JDTerrazas" <JDTerrazas@discussions.microsoft.com> wrote in message
news:8E808B1A-6C6C-4807-A888-BED4EA257B68@microsoft.com...
> 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: 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: Create System DSN
    ... The file ODBCCONF.EXE can create a DSN from command line but I can't create ... a DSN with correct parameters, ... > Is there a way to create a DSN directly from CMD window, I mean with command? ... > Thnx. ...
    (microsoft.public.data.odbc)
  • 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)