I have an application that works with different databaese and different versions of ASA. When I start the application, I would like to know, if I am...

Claude

09-07-2009 08:32 AM
Glenn Paulley [Sybase iAnywhere]

Hi, I have experienced the second time a database server on a 32bit Windows Server 2003 which stops responding to new requests with a high CPU...

Martin

09-07-2009 07:23 AM
Martin

SQL Anywhere Network Server Version 11.0.1.2250 Advanced edition 16 logical processor(s) on 4 physical processor(s) detected. Running Windows 2003...

Rachan Terrell

09-04-2009 02:30 PM
Glenn Paulley [Sybase iAnywhere]

PB 9.0.2 ebf 3044 We attempted to move out database to a new server and can see that the server engine is running on the server. We can connect to...

Loya Kelso

09-04-2009 10:24 AM
Kory Hodgson (Sybase iAnywhere)

Hi I notice when I do a backup on a database with the following begin declare vDest varchar (240); declare vDay varchar (20); set vDay = convert...

Roshintosh

09-04-2009 09:30 AM
Reg Domaratzki [Sybase iAnywhere]

Hi all, I would like to use ASA as DB server on my web application. I use JBOSS/Hibernate (connect to database as one user, multithread). How many...

Tomek

09-04-2009 08:56 AM
Josh Savill [Sybase]

We can use Sybase Central to easily setup a foreigh key on a child table whose column value is null. Howerer we cannot seem to do this with systax....

Mike Marston

09-03-2009 11:14 AM
FalseDawn

Hi all, I have a new customer who does not want to give me any access to their server. I have bought an OEM sql anywhere 11.0.1. and i want to use...

JVL

09-03-2009 09:48 AM
Breck Carter [TeamSybase]

Hello, we tested the SA 11.0.1.2276 with the developer edition to our satisfaction. Next we want to change it to an enterprise edition (without...

Peter Barth

09-02-2009 08:49 PM
Kory Hodgson (Sybase iAnywhere)

Hi All. We are migrating from v9.0 to v11 sybase. Is there a way to uninstall Sybase v9 silently? Appreciate any help.

wndr

09-02-2009 03:37 PM
wndr

Greetings, how to build a GRANT CONNECT TO "user" IDENTIFIED BY ENCRYPTED... statement from sysuserperm view password column? SA 11.0.1 It was...

Pavel Karady

09-02-2009 03:30 AM
Volker Barth

There was a thread with a registry setting that fixed the Java error being produced by Sybase Central 4.3, under Windows 7, and it had to do with a...

NoWayJose

09-01-2009 10:06 AM
Jeff Albion [Sybase iAnywhere]

I am not very familiar with Sybase database systems and tools, but have managed to install and use "dbisql" to retrieve data from a command line...

gwiens

09-01-2009 12:33 AM
Chis Keating (Sybase iAnywhere)

Hello, Latest EBF for V11.01 SCJVIEW Options - "Show welcome window at startup" is not checked. It does anyway.

Robert Paresi

08-31-2009 05:00 PM
Jeff Albion [Sybase iAnywhere]

Hi, I am trying to use iAnywhere.Data.Asaclient from my C# (.NETFX 3.5) program to access SQL Anywhere 9.0.2 db. The problem is the performance. I...

a.sahan

08-31-2009 04:52 PM
a.sahan

Hello all...I was using ISQL and executing a few SELECT queries. My question is: when I execute a query in the ISQL environment that has a column...

Mark

08-31-2009 11:49 AM
Mark

This version seems a lot more stable in our DBRemote/mirroring environment (Windows XP). 4 days with no problems so far, although I've probably...

FalseDawn

08-31-2009 11:18 AM
FalseDawn

Running Sql Anywhere 9.0.2 on a standard 2008 windows server running in a virtual machine. Condition: C++ application Copy 20mb database to server...

Kyle Danielson

08-31-2009 10:08 AM
Nick Elson [Sybase iAnywhere]

Hello, How can I change the default isolation level for JDBC connections? I´ve already changed "dbo.sp_mda" and "dbo.sp_tsql_environment"...

Thiago

08-31-2009 10:07 AM
Jeff Albion [Sybase iAnywhere]

Hello, I´d like to know how can I get the statement that is running for a specific connection. The following SQL command returns NULL in the Value...

Thiago

08-28-2009 02:32 PM
Thiago

Hello, i have a problem with one of my SA 10.0.1.3903 installations. Sometimes, all client connections will be lost. I found in the console log file...

sybase.news.spam@elomagic.de

08-28-2009 11:25 AM
Nick Elson [Sybase iAnywhere]

Hello, Is there a way to protect a procedure to not be able to be dropped even by a user with dba authority. I am trying to secure accesses to a...

Jon

08-28-2009 03:31 AM
Volker Barth

Dear all, Will ASA 8.0.3 work on windows 2008 please ? If not , which version will ? TIA JVL

JVL

08-28-2009 01:34 AM
JVL

Greetings, I've got a large SELECT statement which when run for the 1st time, is using a particular index on a table (among many others), then some...

Pavel Karady

08-27-2009 03:24 PM
Glenn Paulley [Sybase iAnywhere]

I have created a database using Sybase Central 6 and it is running on SQL Anywhere Personal Server 11 (Dev Edition). How do I create an...

Victor Roman

08-27-2009 03:08 PM
Chis Keating (Sybase iAnywhere)

I have a PowerBuilder 11.5 application creating an ODBC connection to a SQLA9 database using the SQLA10 ODBC drivers. It errors out saying...

Jason 'Bug' Fenter [TeamSybase]

08-27-2009 02:42 PM
Chis Keating (Sybase iAnywhere)

Hi all, Is there a quick/easy way to determine how many licenses/licensed seats a certain asa engine has ? ASA 8.0. TIA JVL

JVL

08-27-2009 02:33 PM
JVL

SQL Anywhere 9 Is there a limitation on the characters used? When i selected a databasefile from a folder with Russian characters they are...

Ontsnapt

08-27-2009 10:21 AM
John Smirnios [Sybase]

Hi all, I have registered for SUP on their website 5 times over the last month. Should I be expecting a phone call or an email or something through...

Shao Chan

08-27-2009 05:02 AM
Shao Chan

This seems to happen in 9.0.2 and 11.0.1 : Foreign key defined to allow nulls - shows correctly in Sybase Central. Unload the structure - all seems...

Justin Willey

08-26-2009 07:32 PM
Nick Elson [Sybase iAnywhere]

I'm starting a sqla11 setup at a new customer site. The customer wants to know which ports to open. I replied 2638 and 49152. He then asked if those...

Doug Stone

08-26-2009 03:26 PM
Graeme Perrow [Sybase iAnywhere]

Hello all...I have a dwo that has a SQL Select statement with the followings lines: SELECT "dba"."judge"."judg_person_id"...

Mark

08-26-2009 01:30 PM
Mark

I have a transaction log file that is about 800 MB in size. If I use the dbtran utility it generates a plain ASCII SQL file of about 15 MB in...

at

08-26-2009 10:10 AM
John Smirnios [Sybase]

Please could anybody here clarify ODBC issues of 32-bit and 64-bit systems? I have the following problems: I have upgraded my dev machine to 64-bit...

at

08-26-2009 06:21 AM
at

I have installed SQL Anywhere 11 Developer Edition (newest version; file name SQLAnywhere11_Windows_Developer_11.0.1.exe) with default choices (full...

Andreas Wacknitz

08-26-2009 05:09 AM
Shao Chan

Hi. I recently installed a sqla11 server, license for 10 users. The customer then purchased another 5 seats. How do I add those five...

Doug Stone

08-25-2009 03:32 PM
Doug Stone

The next script is part of a procedure declare cursorX dynamic scroll cursor for select distinct tmp.variablex from dba.TABLE as...

NullZer0

08-25-2009 12:59 PM
NullZer0

Hi. I am moving a customer from sqla8 to sqla11. When I run dbunload, thru SC, I see the following...

Doug Stone

08-25-2009 11:40 AM
Nick Elson [Sybase iAnywhere]

I have a customer that is concerned about the size of a database file. It has been consistent at about 700MB for a long time. We added about...

David DeRam

08-25-2009 10:35 AM
John Smirnios [Sybase]

Hi all, is there a way to register the plugin for SQL Anywhere 9 (C:\Program Files\Sybase\SQL Anywhere 9\java\asaplugin.jar) into Sybase...

MWietscher

08-25-2009 10:03 AM
MWietscher

Hello all...I am migrating our Sybase ASA databases from ASA 9.03 to SQLAnyWhere 11.0.1. I have noticed that I must use double quotes in columns...

Mark

08-25-2009 09:25 AM
Mark

I had a customer's database get an assertion 110300. Does anyone know what this assertion is? The database is ASA 10.0.1 build 3873. Thanks

Bill Williams

08-25-2009 09:00 AM
Chis Keating (Sybase iAnywhere)

Hi all, I have been searching high and low on the Sybase webpage to find this. Upfront, I know diddly-squat about SQL Anywhere... But we have a SQL...

lhundertwasser

08-25-2009 08:52 AM
Chis Keating (Sybase iAnywhere)

Hi I have a (longish - 3500 lines) SQLServer script that contains the definition of a data structure I want to port to SQLAnywhere (v10)....

Justin Willey

08-24-2009 11:13 AM
Volker Barth

Greetings, 32-bit ASA 9 ODBC drivers should work on a 64-bit machine? The error message is Driver's ConfigDSN, ConfigDriver, or ConfigTranslator...

Pavel Karady

08-24-2009 10:01 AM
Pavel Karady

Hi. Is there any SA11 64-bit developer edition for free download? Is installing SA11 32-bit version, and applying a 64-bit EBF on it later,...

Pavel Karady

08-24-2009 09:59 AM
Pavel Karady

Hello! I have strange problem. In SQL statement: SELECT p.datumdokumenta,p.sifrastranke,naziv1,(if p.veznazapstevprometa='0' then p.veznidokument...

Tomaz

08-24-2009 06:54 AM
Chris Werner

Hi guys, I'm using SQL Anywhere 9.0.2 3702 on Windows 2003 server. I was wondering how to change the column order of a particular table without...

Christopher Ceniza

08-24-2009 02:42 AM
Christopher Ceniza

Hello, We have been using dbShrink and dbExpand to compress/decompress the database. After we upgrade from 9.0.2 to 11.0.1, these two commands are...

Sudarat

08-21-2009 12:42 PM
Nick Elson [Sybase iAnywhere]

Anywhere Server 11.0.1 is very slow (installed on Server hardware is a IBM X3650 with 1 CPU Xeon Quadcore 2 Ghz, 4 GB RAM RAID 1 140GB (2 disks SAS)...

NullZer0

08-21-2009 10:18 AM
Kory Hodgson (Sybase iAnywhere)