Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ODBC connection in cmd

3 posts in General Discussion Last posting was on 2009-03-25 14:42:34.0Z
Aron Posted on 2009-03-24 18:00:07.0Z
Sender: 6f69.49c91f4a.1804289383@sybase.com
From: Aron
Newsgroups: ianywhere.public.general
Subject: ODBC connection in cmd
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49c91fa7.6f7a.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Mar 2009 10:00:07 -0800
X-Trace: forums-1-dub 1237917607 10.22.241.41 (24 Mar 2009 10:00:07 -0800)
X-Original-Trace: 24 Mar 2009 10:00:07 -0800, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7429
Article PK: 5843

Hi, we currently have SQL Anywhere version 8. Is there a
way to setup an ODBC connection using MSDOS rather than
going into the ODBC Administrator.

Thanks


Kory Hodgson [Sybase iAnywhere] Posted on 2009-03-24 18:11:56.0Z
From: "Kory Hodgson [Sybase iAnywhere]" <khodgson_nospam@sybase.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ODBC connection in cmd
References: <49c91fa7.6f7a.1681692777@sybase.com>
In-Reply-To: <49c91fa7.6f7a.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49c9226c$1@forums-1-dub>
Date: 24 Mar 2009 10:11:56 -0800
X-Trace: forums-1-dub 1237918316 10.22.241.152 (24 Mar 2009 10:11:56 -0800)
X-Original-Trace: 24 Mar 2009 10:11:56 -0800, vip152.sybase.com
Lines: 17
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7430
Article PK: 5846

You can use the dbdsn utility that ships with SQL Anywhere to create SQL
Anywhere ODBC data sources from the command line. Look up dbdsn in the
supplied help documents for full usage instructions.

Thanks

Kory Hodgson
Sybase iAnywhere

Aron wrote:
> Hi, we currently have SQL Anywhere version 8. Is there a
> way to setup an ODBC connection using MSDOS rather than
> going into the ODBC Administrator.
>
> Thanks


David Fishburn [Sybase] Posted on 2009-03-25 14:42:34.0Z
Newsgroups: ianywhere.public.general
Subject: Re: ODBC connection in cmd
From: "David Fishburn [Sybase]" <fishburn_spam_off@ianywhere.com>
References: <49c91fa7.6f7a.1681692777@sybase.com> <49c9226c$1@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns9BD96CF17E893fishburnsybasecom@10.22.241.106>
User-Agent: Xnews/2005.10.18
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 25 Mar 2009 06:42:34 -0800
X-Trace: forums-1-dub 1237992154 10.22.241.152 (25 Mar 2009 06:42:34 -0800)
X-Original-Trace: 25 Mar 2009 06:42:34 -0800, vip152.sybase.com
Lines: 51
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7432
Article PK: 5847

"Kory Hodgson [Sybase iAnywhere]" <khodgson_nospam@sybase.com> wrote in
news:49c9226c$1@forums-1-dub
of ianywhere.public.general:

KH> You can use the dbdsn utility that ships with SQL Anywhere to create
SQL
KH> Anywhere ODBC data sources from the command line. Look up dbdsn in
the
KH> supplied help documents for full usage instructions.

FYI, the easiest way to use it is:

Create your ODBC DSN as usual.
The run this command line:

dbdsn -cm -gs "SQL Anywhere 11 Demo"
or
dbdsn -cm -gu "SQL Anywhere 10 Demo"

You get back the exact dbdsn command line that you need to run to
create the same DSN (but in an automated way):

dbdsn -y -ws "SQL Anywhere 11 Demo" -c "UID=DBA;PWD=sql;DBF='C:
\Documents and Settings\All Users\Documents\SQL Anywhere 11\Samples
\demo.db';ENG=demo11;START=C:\SA11\Bin32
\dbeng11.exe;ASTOP=YES;Description='SQL Anywhere 11 Sample Database'"

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng11 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList

Documentation
http://dcx.sybase.com/