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

2 posts in General Discussion Last posting was on 2002-10-21 15:15:44.0Z
cbanister Posted on 2002-10-19 01:29:44.0Z
From: cbanister
Date: Fri, 18 Oct 2002 21:29:44 -0400
Newsgroups: ianywhere.public.general
Subject: ODBC
Message-ID: <22D3512C53BA66820008375885256C57.0008377685256C57@webforums>
Lines: 8
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:526
Article PK: 2345

When I set up the ODBC connection for an PowerBuilder application
running with ASA8I include a startline that allocates a certain
amount of memory, however when I test the connection I get an error
stating that the client is out of memory,the max I can put in is
1.5 Gb.The machine runs Windows 2000 Advanced Server and is loaded
with 8 Gb of RAM. Is there a work around so that Sybase can use 7Gb?

Please respond to christian@globalnetcommunications.net


Raymond_Kwong Posted on 2002-10-21 15:15:44.0Z
From: Raymond_Kwong
Date: Mon, 21 Oct 2002 11:15:44 -0400
Newsgroups: ianywhere.public.general
Subject: Re: ODBC
Message-ID: <01A953D5CCDDF6710053D67F85256C59.000BA05885256C57@webforums>
References: <22D3512C53BA66820008375885256C57.0008377685256C57@webforums>
Lines: 18
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:520
Article PK: 2337

It looks like you have hit the limit of maxiumum non-AWE cache size. The
documentation at

Adaptive Server Anywhere Database Administration Guide
5. The Database Server
The database server
Database server options
-cw server option

should be of help. If you really need 7GB of cache to run the database,
that piece of documentation should be of use for you to use AWE caching to
run databases with larger cache sizes.

P.S. You'll also need to apply the bug fix for 8.0.1 build 3059 or above,
8.0.0 build 2350 or above

Raymond Kwong
iAnywhere Solutions