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

2 posts in General Discussion Last posting was on 2008-05-21 21:29:50.0Z
Loya Posted on 2008-05-21 20:45:38.0Z
Reply-To: "Loya" <lkelso@isprit.com>
From: "Loya" <lkelso@isprit.com>
Newsgroups: ianywhere.public.general
Subject: ODBC connection
Lines: 12
Organization: Isprit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <483489f2$1@forums-1-dub>
Date: 21 May 2008 13:45:38 -0700
X-Trace: forums-1-dub 1211402738 10.22.241.152 (21 May 2008 13:45:38 -0700)
X-Original-Trace: 21 May 2008 13:45:38 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6851
Article PK: 5088

Hi
I am a user of version 9.0.2 and want to create an install script to
automatically install our application on the server and each client.

I am stuck on how to dynamically set up the odbc connection on the server
and the client. I have looked at the dbdsn command-line utility. But I am
unclear if that is for the server or the client or for both.

Thanks,
Loya


Jeff Albion (Sybase iAnywhere) Posted on 2008-05-21 21:29:50.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ODBC connection
References: <483489f2$1@forums-1-dub>
In-Reply-To: <483489f2$1@forums-1-dub>
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: <4834944e$1@forums-1-dub>
Date: 21 May 2008 14:29:50 -0700
X-Trace: forums-1-dub 1211405390 10.22.241.152 (21 May 2008 14:29:50 -0700)
X-Original-Trace: 21 May 2008 14:29:50 -0700, vip152.sybase.com
Lines: 48
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6852
Article PK: 5086

Loya,

Which operating system is this for? I'll assume "Windows" for my
response, but if this is on Linux / UNIX, the idea is similar.

---

Generally, the ODBC information is for the client and specifies how to
connect to the server (e.g. username, password, engine name, host IP, etc.)

Are you running a network server or a personal server (local connections
only)?

If it's the network server, you'll need a mechanism on the host machine
to start the database before a client can connect to it. Generally this
is accomplished via a user-issued command (e.g. a shortcut, Start->Run,
type it a Command Prompt, etc.) or a Windows Service (See:
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbdaen9/00000609.htm
)

If it's the personal server, you can specify that the engine is
auto-started when a connection attempts to use that DSN. (See the
database tab "Start Engine Automatically" in the DSN configuration
panel). Otherwise, you should use one of the above methods to start the
server as above before connecting.

In both cases, the DSN should give the "appropriate" information to
connect to the server. This would include username, password, engine
name, database name, and any network parameters required to connect.

Regards,

Loya wrote:
> I am a user of version 9.0.2 and want to create an install script to
> automatically install our application on the server and each client.
>
> I am stuck on how to dynamically set up the odbc connection on the server
> and the client. I have looked at the dbdsn command-line utility. But I am
> unclear if that is for the server or the client or for both.

--
Jeff Albion, Product Support Analyst
Sybase iAnywhere

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0