To determine regarding to FIPS setup we executed this command: SELECT property ( 'IsFipsAvailable' ) FipsAva, property ( 'FipsMode' ) FipsMode Are...

Rachan Terrell

09-17-2009 01:33 PM
Bruce Hay

We run 2 sybase databases and 1 Arbiter process on a machine. One of the databases is 1.5gb in size (not replicated), the other is about 500mb...

Roshintosh

09-17-2009 12:08 PM
Glenn Paulley [Sybase iAnywhere]

Is it possible to setup database mirroring with one primary server and multiple mirror servers? Thank you for your help. Best regards, Rachan Terrell

Rachan Terrell

09-17-2009 10:25 AM
Charles.Gogolin@stanleyassociates.com

We set up a mirrored database system that have three machines (two servers and one arbiter) and the high availability option set up. We are running...

Rachan Terrell

09-17-2009 10:04 AM
Charles.Gogolin@stanleyassociates.com

We're using the ado.net provider for SQL Anywhere 10.0.1 and call stored procedures. Although our stored procedure already encapsulates an insert in...

srsanchez75@googlemail.com

09-17-2009 09:33 AM
Reg Domaratzki [Sybase iAnywhere]

Hi. We have a customer that just upgraded to sqla 11.0.1.2044. They are seeing a problem which we cannot replicate. Are there any known issues with...

Doug Stone

09-17-2009 09:31 AM
Reg Domaratzki [Sybase iAnywhere]

Bhavik Patel

09-17-2009 04:51 AM
Bhavik Patel

ASA 8.0.3.5574 Hi, within one project we use xp_sendmail for sending some emails with attachment. I'm sure this already worked correctly. But...

Fabian Knauf

09-17-2009 04:10 AM
Fabian Knauf

Hi, Latest EBF for Sybase Central. Options ... show welcome window at startup. Uncheck it. Close Sybase Central Reopen

Robert Paresi

09-16-2009 06:53 PM
Robert Paresi

We started with v11.00, succesfully tested High Availability. Later on Installed v11.01 up to EBF 2250 with FIPS. We understand that both...

Rachan Terrell

09-16-2009 04:46 PM
Rachan Terrell

Hi, Is there any way to find out what fired a trigger? I have AFTER INSERT trigger for example. I need to know that it was fired by a stored...

Blueman

09-16-2009 11:08 AM
Blueman

Nick, After looking over the logs and trying things out, I've got it working with the following...

Shenn Sellers

09-16-2009 10:34 AM
Graeme Perrow [Sybase iAnywhere]

Hi all, I have the following table: Col_id: integer autoincrement PK Color_id: smallint I insert a row in the table every time a color is used. So...

Mgs

09-16-2009 09:49 AM
Mgs

Hi, I am using the latest V11 database and I get the following error message: "Cursor not in a valid state" What does that mean??? SELECT

Robert Paresi

09-15-2009 02:29 PM
Glenn Paulley [Sybase iAnywhere]

Hi, In one of our customer places, we are facing issue of the database checkpoint is happening once in an hour(Windows). There is no specific...

knazare@bmc.com

09-15-2009 12:50 PM
Jeff Albion [Sybase iAnywhere]

Does Sybase SQL support something like LIMIT and OFFSET to read only a defined amount of rows?

Stas

09-15-2009 10:47 AM
Stas

SQL Anywhere 10.0.1.3831 E. 2009-09-11 21:55:41. SQL statement failed: (-305) I/O error Fatal error: A disk read from file...

Sohaib Uthmani

09-15-2009 10:29 AM
Jeff Albion [Sybase iAnywhere]

I have to create a trigger that will fire when a row in a table is inserted or updated, the trigger will copy the new row that is inserted or deleted...

Zoe

09-15-2009 10:22 AM
Nick Elson [Sybase iAnywhere]

Dear Gurus I installed ASA11 developer edition, but could't find runtime for Mobile/Desktop. From where I can download/install runtime version of...

Antony

09-15-2009 01:46 AM
Antony

I have a sqla9 customer where our pb9 app (which is installed on many workstations and running in client/server mode) will start running slower and...

Doug Stone

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

I spend much of my day remoting into customer sqla servers. Depending on the method used to remote me in (and, I suppose, the "interact with...

Doug Stone

09-14-2009 08:36 PM
Chis Keating (Sybase iAnywhere)

We are using SA10 EBF 3805(Linux) and 3807(Windows) for our product. Using follow stored procedure(SP) - create procedure sp_adjust_required_table ( ...

Hanan Brener

09-14-2009 01:10 PM
Hanan Brener

I have a directory access server created with the following command: CREATE SERVER "createqadboutput" CLASS 'DIRECTORY' USING...

Marvin

09-14-2009 10:57 AM
Karim Khamis [Sybase iAnywhere]

Hi All Running ASA 9.0.2.3661, I have a situation where one of the fields (varchar(4000)) with a table contains an xml string as shown...

Roger Peffers

09-14-2009 10:07 AM
Kory Hodgson (Sybase iAnywhere)

The following SQL Anywhere 11.0.1 Help topic refers to the "General page" and "Server Options" page of some GUI or utility that is not named... what...

Breck Carter [TeamSybase]

09-14-2009 08:04 AM
Breck Carter [TeamSybase]

Hi, We have a sybase v6 database, and we use a small script to backup each night.dbbackup -c "dsn=nma" -y -q n:\nm_backupthis generates two files one...

Yurov Ardyy

09-14-2009 07:01 AM
Jeff Albion [Sybase iAnywhere]

Hi,all Does Sql anywhere or ultralite support windows ce 5? Not windows mobile/ppc.

Ivan.deng

09-14-2009 06:38 AM
Jeff Albion [Sybase iAnywhere]

The server name is not the IP and port. It is the name of the of the engine. From the screen cap of Sybase Central, the engine name is next to the...

Chis Keating (Sybase iAnywhere)

09-13-2009 03:59 AM
Khoo Yh

In addition, there is a folder being created in the Home group called "SYBASE". This also should be going in temp, app data, program data -...

Robert Paresi

09-12-2009 02:08 PM
Robert Paresi

Hello, Sybase is still not using proper folders in Windows Vista and Windows 7 ... even Version 11, and I'm still wondering why this is not made a...

Robert Paresi

09-12-2009 02:06 PM
Robert Paresi

I have a stored procedure which uses a cursor. When running this procedure I get an error message after some time saying that there are too many...

at

09-12-2009 05:29 AM
at

With sqla 10 and 11 there is a handy deployment folder which allows a client msi to be created. Is there an equivalent method for sqla 9? I just...

Doug Stone

09-11-2009 10:05 PM
Robert Paresi

We've code to create copies of a set of records that periodically fails.. not always, of course, just periodically.. with the error message:...

P Merritt

09-11-2009 03:23 PM
Nick Elson [Sybase iAnywhere]

We purchased SQL Anywhere Runtime v 10.0.1 with the intention of redistributing it to our clients as allowed by item #1 in the license...

Business Automation Services

09-11-2009 03:10 PM
Nick Elson [Sybase iAnywhere]

I have a C# application that reads in a bunch of data from a sql anywhere db table. It then goes record by record, does some processing and...

Jab

09-11-2009 11:25 AM
Jab

Hello, how can I find out which sql statements from database users are currently processed and how long they already took? I want to find out which...

Marten Lehmann

09-11-2009 07:00 AM
Marten Lehmann

Hi I'm trying to install sql anywhere in my ubuntu 8.04 64 bit machine, but following error stops me when runs the setup files here is the...

darshana

09-11-2009 05:50 AM
Darshana

Hi there, I'm trying to connect to a SQLAny10 DB on a remote server from OpenOffice running on Mac OS/X 10.6. I've already tried jconn2.jar and...

Rado Rethmann

09-10-2009 05:08 PM
Rado Rethmann

SQL Anywhere 11 displays commas in integer data. For example, Interactive SQL version 11 displays a primary key of 123456789 as 123,456,789. Sybase...

Laurie Johnson

09-10-2009 02:46 PM
Laurie Johnson

We have some local temporary tables with connetion specific information. We use this tables in triggers e.g. to update the record with the current...

Arthur Hefti

09-10-2009 09:57 AM
Krisztián Pintér

Hello all...we recently migrated to SQLAnywhere 11.0.1.2044 with minimal problems. The one problem we are having though, is that we are having...

Mark

09-10-2009 09:41 AM
Mark

Without specifying a port paramter, the first database start at port 2638. I set up a second database ( as another service ) and it starts on...

Claude

09-09-2009 06:27 PM
Graeme Perrow [Sybase iAnywhere]

Encoutering the following assertion error - any insight would be appreciated as to why occurring. Is there a reference to the error codes for...

DMH

09-09-2009 03:43 PM
DMH

Hi. I have installed the SQLAnywhere11.0.1 Developer Edition on a Microsoft Windows Server 2003 Standard Edition. The Problem is, that Sybase Central...

Thomas Kehl

09-09-2009 12:40 PM
Ray Ruvinskiy [Sybase iAnywhere]

Hello We are currently upgrading to Windows 7 (final version, not Beta or RTM). We are using ODBC System DSN to connect to SA Server; Here's the...

Michael Thomas

09-09-2009 06:21 AM
Michael Thomas

Hi All, How to identify a window is an abstract window(class) or not? How to findout abstract classes in that application? Regards, Charu

Revanth

09-09-2009 02:21 AM
Revanth

I have written some procedures in C#. They are called from triggers, stored procedures etc. When processing some thousand records the dbextclr11.exe...

at

09-08-2009 04:07 PM
Karim Khamis [Sybase iAnywhere]

Does anyone know what port, Protocols and Services (PPS) that SQL Anywhere Monitor use? Thanks in advance for all your help. Best regards, Rachan...

Rachan Terrell

09-08-2009 02:02 PM
Graeme Perrow [Sybase iAnywhere]

Hi, We are testing SQLAnywhere Monitor . Everything is fine, except on ONE database : when adding the ressource, everything is OK, but the...

ps

09-08-2009 01:51 PM
Dan Petker [Sybase iAnywhere]

Hello. I recently upgraded to Mac OS Snow Leopard, and now I can't connect to databases using dbisql. Whenever I try, I get: Cannot find...

JessD

09-08-2009 11:45 AM
Ray Ruvinskiy [Sybase iAnywhere]