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.

Help for Sybase SQL Anywhere Database Engine Version 5.5.03

7 posts in General Discussion Last posting was on 2008-03-06 15:40:49.0Z
Andre Wichert Posted on 2008-03-01 19:33:12.0Z
From: Andre Wichert <want_your_spam@gmx.net>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Help for Sybase SQL Anywhere Database Engine Version 5.5.03
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47c9af78$1@forums-1-dub>
Date: 1 Mar 2008 11:33:12 -0800
X-Trace: forums-1-dub 1204399992 10.22.241.152 (1 Mar 2008 11:33:12 -0800)
X-Original-Trace: 1 Mar 2008 11:33:12 -0800, vip152.sybase.com
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6731
Article PK: 4977

Hello,

sorry, for possible wrong newsgroup - don't really know where to post.

I got a problem using a program, which uses Sybase SQL Anywhere Database
Engine Version 5.5.03.
What is nessicary for using these engine? I want to install that program
on a restricted client in a school and have now to know, what changes in
configuration I have to do.

Thanks for your help.

Best regards,
Andre


Reg Domaratzki (Sybase iAnywhere) Posted on 2008-03-03 14:46:34.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Help for Sybase SQL Anywhere Database Engine Version 5.5.03
From: "Reg Domaratzki (Sybase iAnywhere)" <FirstName.LastName@ianywhere.com>
References: <47c9af78$1@forums-1-dub>
Organization: Sybase iAnywhere
Message-ID: <Xns9A566372FEE59RegDSybiAnywhere@10.22.241.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 3 Mar 2008 06:46:34 -0800
X-Trace: forums-1-dub 1204555594 10.22.241.152 (3 Mar 2008 06:46:34 -0800)
X-Original-Trace: 3 Mar 2008 06:46:34 -0800, vip152.sybase.com
Lines: 36
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6733
Article PK: 4978

Andre Wichert <want_your_spam@gmx.net> wrote in news:47c9af78$1@forums-1-
dub:

> Hello,
>
> sorry, for possible wrong newsgroup - don't really know where to post.
>
> I got a problem using a program, which uses Sybase SQL Anywhere
Database
> Engine Version 5.5.03.
> What is nessicary for using these engine? I want to install that
program
> on a restricted client in a school and have now to know, what changes
in
> configuration I have to do.
>
> Thanks for your help.
>
> Best regards,
> Andre
>

You've asked a very generate question along the lines of "how do I use
your product". Can you be more specific about how you will be using SQL
Anywhere and what problems you have run into?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"


Andre Wichert Posted on 2008-03-04 10:29:40.0Z
From: Andre Wichert <want_your_spam@gmx.net>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Help for Sybase SQL Anywhere Database Engine Version 5.5.03
References: <47c9af78$1@forums-1-dub> <Xns9A566372FEE59RegDSybiAnywhere@10.22.241.106>
In-Reply-To: <Xns9A566372FEE59RegDSybiAnywhere@10.22.241.106>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47cd2494@forums-1-dub>
Date: 4 Mar 2008 02:29:40 -0800
X-Trace: forums-1-dub 1204626580 10.22.241.152 (4 Mar 2008 02:29:40 -0800)
X-Original-Trace: 4 Mar 2008 02:29:40 -0800, vip152.sybase.com
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6737
Article PK: 4982

Reg Domaratzki (Sybase iAnywhere) schrieb:

> You've asked a very generate question along the lines of "how do I use
> your product". Can you be more specific about how you will be using SQL
> Anywhere and what problems you have run into?
>

Sorry -
the database is used in a program (learning game) called "Mission
BluePlanet" from the "Bundesministerium fÃŒr Umwelt, Naturschutz und
Reaktorsicherheit". It seems that the users in the program where saved
in that database enging.

The operatin system is a Windows XP Version with SP2.
The students:
- can't write in the registry or any folder from the systemroot (here C:)
- they don't have any internet-access normaly

The Question is: did the database write any things to the reg or
windwos-folder (for example) or need other clearings?


"Stephen Rice" Posted on 2008-03-04 13:48:01.0Z
From: "Stephen Rice" <srice[at]sybase[dot]com>
Newsgroups: ianywhere.public.general
References: <47c9af78$1@forums-1-dub> <Xns9A566372FEE59RegDSybiAnywhere@10.22.241.106> <47cd2494@forums-1-dub>
Subject: Re: Help for Sybase SQL Anywhere Database Engine Version 5.5.03
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47cd5311$1@forums-1-dub>
Date: 4 Mar 2008 05:48:01 -0800
X-Trace: forums-1-dub 1204638481 10.22.241.152 (4 Mar 2008 05:48:01 -0800)
X-Original-Trace: 4 Mar 2008 05:48:01 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6738
Article PK: 4983

The database engine only writes to the database file and transaction log.
It also creates temporary files in the temporary file directory

--
/steve
Stephen Rice
Sybase iAnywhere

"Andre Wichert" <want_your_spam@gmx.net> wrote in message
news:47cd2494@forums-1-dub...
> Reg Domaratzki (Sybase iAnywhere) schrieb:
>> You've asked a very generate question along the lines of "how do I use
>> your product". Can you be more specific about how you will be using SQL
>> Anywhere and what problems you have run into?
>>
>
> Sorry -
> the database is used in a program (learning game) called "Mission
> BluePlanet" from the "Bundesministerium für Umwelt, Naturschutz und
> Reaktorsicherheit". It seems that the users in the program where saved in
> that database enging.
>
> The operatin system is a Windows XP Version with SP2.
> The students:
> - can't write in the registry or any folder from the systemroot (here C:)
> - they don't have any internet-access normaly
>
> The Question is: did the database write any things to the reg or
> windwos-folder (for example) or need other clearings?


"Frank Ploessel" <fpl... Posted on 2008-03-04 17:08:32.0Z
Subject: Re: Help for Sybase SQL Anywhere Database Engine Version 5.5.03
From: "Frank Ploessel" <fpl...@d_e.i_m_s_h_e_a_l_t_h.c_o_m>
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
References: <47c9af78$1@forums-1-dub> <Xns9A566372FEE59RegDSybiAnywhere@10.22.241.106> <47cd2494@forums-1-dub>
Content-Transfer-Encoding: 8bit
Message-ID: <op.t7h4keidj0bybf@bonw00164.internal.imsglobal.com>
User-Agent: Opera Mail/9.21 (Win32)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 4 Mar 2008 09:08:32 -0800
X-Trace: forums-1-dub 1204650512 10.22.241.152 (4 Mar 2008 09:08:32 -0800)
X-Original-Trace: 4 Mar 2008 09:08:32 -0800, vip152.sybase.com
Lines: 52
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6740
Article PK: 4985

Andre,

Am I understanding you right that you want to deinstall the program and
search for everything it might have left on disk or in the registry?

The database engine itself does not write any entries to the registry.
There are also few files written by the SQL Anywhere engine: Potentially,
some temporary files (type .tmp) could be left in the temp directory. To
determine that, SQL Anywhere uses the following environment variables in
this order: ASTMP TMP TMPDIR TEMP. The first of these variables found is
used for the directory.
Apart from that, there is obviously the db file and potentially a log file
and mirror log file (.log, .mlg). But I would not assume that mirror logs
are used, as they are more used for high availability solutions.

Another issue might be the application (and database) installation which
might also create registry entries and leave other files. But this would
be application specific.
In many cases, ODBC sources are created for applications accessing SQL
Anywhere databases.
The registry entries for ODBC sources can be found in the registry in the
following locations:
subkeys of HKLM\Software\ODBC\ODBCINST.INI
subkeys of HKLM\Software\ODBC\ODBC.INI
subkeys of HKCU\Software\ODBC\ODBC.INI

Frank


On Tue, 04 Mar 2008 11:29:40 +0100, Andre Wichert <want_your_spam@gmx.net>

wrote:

> Reg Domaratzki (Sybase iAnywhere) schrieb:
>> You've asked a very generate question along the lines of "how do I use
>> your product". Can you be more specific about how you will be using
>> SQL Anywhere and what problems you have run into?
>>
>
> Sorry -
> the database is used in a program (learning game) called "Mission
> BluePlanet" from the "Bundesministerium fÃŒr Umwelt, Naturschutz und
> Reaktorsicherheit". It seems that the users in the program where saved
> in that database enging.
>
> The operatin system is a Windows XP Version with SP2.
> The students:
> - can't write in the registry or any folder from the systemroot (here C:)
> - they don't have any internet-access normaly
>
> The Question is: did the database write any things to the reg or
> windwos-folder (for example) or need other clearings?


Josh Savill Posted on 2008-03-04 17:53:04.0Z
From: Josh Savill <no_spam_jsavill@ianywhere.com>
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Help for Sybase SQL Anywhere Database Engine Version 5.5.03
References: <47c9af78$1@forums-1-dub> <Xns9A566372FEE59RegDSybiAnywhere@10.22.241.106> <47cd2494@forums-1-dub>
In-Reply-To: <47cd2494@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47cd8c80$1@forums-1-dub>
Date: 4 Mar 2008 09:53:04 -0800
X-Trace: forums-1-dub 1204653184 10.22.241.152 (4 Mar 2008 09:53:04 -0800)
X-Original-Trace: 4 Mar 2008 09:53:04 -0800, vip152.sybase.com
Lines: 30
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6741
Article PK: 4986


Andre Wichert wrote:
> Reg Domaratzki (Sybase iAnywhere) schrieb:
>> You've asked a very generate question along the lines of "how do I use
>> your product". Can you be more specific about how you will be using
>> SQL Anywhere and what problems you have run into?
>>
>
> Sorry -
> the database is used in a program (learning game) called "Mission
> BluePlanet" from the "Bundesministerium fÃŒr Umwelt, Naturschutz und
> Reaktorsicherheit". It seems that the users in the program where saved
> in that database enging.
>
> The operatin system is a Windows XP Version with SP2.
> The students:
> - can't write in the registry or any folder from the systemroot (here C:)
> - they don't have any internet-access normaly
>
> The Question is: did the database write any things to the reg or
> windwos-folder (for example) or need other clearings?

Andre,

This document is written for SQL Anywhere 8, but may give you some ideas
on where to look in the registry for entries:
http://www.sybase.com/detail?id=1044099

--
Joshua Savill
Sybase iAnywhere - Product Manager


Andre Wichert Posted on 2008-03-06 15:40:49.0Z
From: Andre Wichert <want_your_spam@gmx.net>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Help for Sybase SQL Anywhere Database Engine Version 5.5.03
References: <47c9af78$1@forums-1-dub> <Xns9A566372FEE59RegDSybiAnywhere@10.22.241.106> <47cd2494@forums-1-dub> <47cd8c80$1@forums-1-dub>
In-Reply-To: <47cd8c80$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47d01081$1@forums-1-dub>
Date: 6 Mar 2008 07:40:49 -0800
X-Trace: forums-1-dub 1204818049 10.22.241.152 (6 Mar 2008 07:40:49 -0800)
X-Original-Trace: 6 Mar 2008 07:40:49 -0800, vip152.sybase.com
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6748
Article PK: 4992

Josh Savill schrieb:

> Andre Wichert wrote:
>> Reg Domaratzki (Sybase iAnywhere) schrieb:
>>> You've asked a very generate question along the lines of "how do I
>>> use your product". Can you be more specific about how you will be
>>> using SQL Anywhere and what problems you have run into?
>>>
>>
>> Sorry -
>> the database is used in a program (learning game) called "Mission
>> BluePlanet" from the "Bundesministerium fÃŒr Umwelt, Naturschutz und
>> Reaktorsicherheit". It seems that the users in the program where saved
>> in that database enging.
>>
>> The operatin system is a Windows XP Version with SP2.
>> The students:
>> - can't write in the registry or any folder from the systemroot (here C:)
>> - they don't have any internet-access normaly
>>
>> The Question is: did the database write any things to the reg or
>> windwos-folder (for example) or need other clearings?
>
> Andre,
>
> This document is written for SQL Anywhere 8, but may give you some ideas
> on where to look in the registry for entries:
> http://www.sybase.com/detail?id=1044099
>

Thanks for reply - I'll try it next week and will respond my achievement