Last week I've got the assertion: *** ERROR *** Assertion failed: 201501 (11.0.1.2303) Page 0x2:0x1 for requested record not a table page I was...

Andrei Iliev

10-19-2009 06:38 AM
Andrei Iliev

Hi, I've got the option of using AWE cache on a 4GB Win 2003 Standard box running, exclusively, an SA 10.0.1.3689 database server. Apart from the...

Roger Holmes

10-16-2009 04:09 PM
John Smirnios [Sybase]

Hi all, How can I change the dbspace assignment of table without RE-CREATE it ? .... consider that this table has many Referencing tables...

Nicola Cisternino

10-16-2009 10:13 AM
Nick Elson [Sybase iAnywhere]

As far as I can see SQL Anywhere has no support for Windows Embedded CE (Windows CE 6). Are there any plans to include it in the list of...

Elias Bröms

10-16-2009 09:55 AM
Elias Bröms

Hello, is there a way to check if logging of sql statetments is enabled on a ASA 9.0 server? I need to query this with via sql. Thank you. Kind...

AH

10-16-2009 02:23 AM
AH

according to manual: 1. dbsrv11 -x tcpip\(PORT=2639\) -su sql -n arbiter -xa "auth=abc;DBN=demo" -xf /Z/ARB/arbiterstate.txt -z -zr all oki 2....

Alex

10-15-2009 03:16 PM
Bruce Hay

Hello Does sybase have a reporting tool program available? I need to track data-changes in different tables, and be able to see what data has...

Jacques

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

Hi, is there a way to find out whether there is a Sybase 32-bit or 64-bit installed? I need this info for a batch- / shell-script... so i need...

10-15-2009 03:42 AM
Volker Barth

We can unload a Database from SQL Anywhere Vers. 5.5 into a SQL 11 Database with the collation cp850 (charset Windows-1252) with the unload-utility...

Thomas Hoffmann

10-14-2009 07:06 PM
Nick Elson [Sybase iAnywhere]

Server ASA 11.0.1.2324 (latest official EBF) on Windows 2003 I have a very strange problem since I use extended stored procedures written in...

at

10-14-2009 04:33 PM
Glenn Paulley [Sybase iAnywhere]

when using sql anywhere 11.0.1 and has patched to 2308, I found that in Delphi 7, using ADOconnection and adotable, click the tablename, it...

antx3

10-14-2009 10:25 AM
Nick Elson [Sybase iAnywhere]

SQL Anywhere Network Server Version 11.0.1.2308 Any one know why we're getting this error: Key violation. Run time SQL error -- ***...

Rachan Terrell

10-13-2009 05:16 PM
Rachan Terrell

Microsoft Security Essentials flagged dbserv11.dll as a problem file and quarantined the file (moved the file). The description is shown below. Is...

Bigger Jake

10-13-2009 05:13 PM
Jeff Albion [Sybase iAnywhere]

I have noticed that there are some binaries found in the 32bit bin that are not found in the 64bit bin folder. I had expected both folders would be...

Kyle Danielson

10-13-2009 04:59 PM
Jeff Albion [Sybase iAnywhere]

Under ASA9 as far as I know, a sain paging technic could be already achieved through the use of SELECT TOP n START AT p + or window...

ZeroCool

10-13-2009 01:53 PM
Breck Carter [TeamSybase]

Hello altogether, after installation of ASA 11.0.1 with the following command line: msiexec /i SQLANY32.msi /qn REGKEY=somekey COMPANYNAME="Some...

Manuel Martin

10-13-2009 12:12 PM
Jeff Albion [Sybase iAnywhere]

How can I check if .db file is fragmented and how can I defragment it to optimize performance.

Deepali

10-13-2009 10:49 AM
Jeff Albion [Sybase iAnywhere]

I just noticed that JOINs with temporary tables are much slower than JOINs with base tables and like to ask if that is typical and what the...

Markus KARG

10-13-2009 08:28 AM
Breck Carter [TeamSybase]

SQL Anywhere has a SQL command "PREPARE TO COMMIT", so obviously it is able to participate in Two Phase Commit scenarios, what is a core demand...

Markus KARG

10-13-2009 05:57 AM
Markus KARG

Hi, I want to use some functions of SA 11.0.1 on a client without installing SQL-Anywhere complete. Please tell me what files I have to copy to...

10-12-2009 07:14 PM
Chris Keating (Sybase iAnywhere)

Hi, I want to recover a database by using the transactionslogfile. I have an image-backup (made by dbbackup.exe) and a modified database. I want wo...

10-12-2009 05:14 AM

Hi, I have a question regarding the High availability feature of a SA 10.0.0.1.3931: Can I have a 64bit Primary Server with a 32bit Mirror? The...

Felix Husse

10-12-2009 03:11 AM
Felix Husse

my friend is getting a Free iphone 16Gb with Xpango, you can get one too: At first click on this link to sing...

ptajik

10-11-2009 01:52 PM
ptajik

Our SqlAnywhere database is currently version 11.0.1. When our database was originally created, an option was selected for it to mimic ASE behavior...

Shawn

10-11-2009 11:14 AM
Breck Carter [TeamSybase]

How can I check if .db file is fragmented and how can I defragment it to optimize performance. Also, there are crystal reports running on the server...

Deepali

10-11-2009 07:28 AM
Deepali

Hi, We have a file in our windows directory: asat001.tmp It's in \windows\temp The file is 109meg

Robert Paresi

10-10-2009 11:12 PM
Glenn Paulley [Sybase iAnywhere]

All my customers are using version 10. I have a new customer that I want to install version 11. I now see that 11 has editions (workgroup,...

Austin Drum

10-09-2009 10:39 AM
Josh Savill [Sybase]

Hi! I want to validate a Database without modifying the Database. The documentation gives two Opportunities... validate a copy of the Database or...

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

I have a SQL Server 2008 SP1 database that communicates successfully (more or less) via SAOLEDB.11 with a SQL Anywhere 11 database. When I use BEGIN...

Breck Carter [TeamSybase]

10-09-2009 07:33 AM
Breck Carter [TeamSybase]

I am relatively new to Sybase so I am trying to gather info for a project to optimize performance for a ASA7 database. I have read ASA 7 database...

Deepali

10-09-2009 05:12 AM
Deepali

ASA 9.0.1.1899 to ASA 11.0.1.2222 ATM we are migrating customer databases from 9.0.1 to 11.0.1. As well we are changing the collation from CP1252 to...

Gerrit Edzards

10-09-2009 03:32 AM
Gerrit Edzards

Hi, How can I determine up to which EBF supports Windows 2003 SP1 x86? Cheers, Shao

Shao Chan

10-08-2009 02:00 PM
Shao Chan

We have a Multi-User Windows application which uses Microsoft Visual Studio 2005 and Sybase SQL Anywhere v8.02 (Embedded SQL). We use installation...

Ken Shibata

10-08-2009 12:08 PM
Ken Shibata

If you were using version 11, you could use: alter procedure procedure1 recompile Unfortunately, this statement is not available in version 9....

Bruce Hay

10-08-2009 10:54 AM
Bruce Hay

When we unload our Database in dat-Files with ASA 9 or ASA 11 (Dataformat: cp850), we can't reload the exported data & structur in a new ASA 11 UTF-8...

Thomas Hoffmann

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

Version 9.0.2 I am attempting to recover a database in which the only backup is corrupt and multiple log files need to be applied. I have...

Jim Diaz

10-08-2009 09:57 AM
Breck Carter [TeamSybase]

This is a SQL Server 2008 error message, probably SQL Server's fault, but I'm asking the question here because it involves SAOLEDB.11 to copy data...

Breck Carter [TeamSybase]

10-08-2009 09:34 AM
Breck Carter [TeamSybase]

SQL Anywhere Network Server Version 11.0.1.2044 linux going trough manual 1. start arbiter dbsrv11 -x tcpip(PORT=2639) -su sql -n arbiter...

Alex

10-08-2009 08:44 AM
Ray Ruvinskiy [Sybase iAnywhere]

From time to time while trying to connect to SA11 Server I receive the following error: "Connection error: Found server but communication error...

Andrei Iliev

10-08-2009 06:16 AM
Andrei Iliev

I have a user which has a database on a harddrive that is failing. The database is corrupt, the validated database on the harddrive is also...

Dave Westphal

10-07-2009 03:46 PM
Kory Hodgson (Sybase iAnywhere)

Hello all...Does anyone know when SQLAnywhere 11.0.2 will be coming out? Just curious.

Mark

10-07-2009 02:46 PM
Josh Savill [Sybase]

SQL Anywhere 9.0.2.3228 We often use procedures to return result sets in which the ordered by or where clause is specified by parameters. To do...

Jim Diaz

10-07-2009 02:39 PM
Jim Diaz

One customer database was corrupted, tried all the SQL Anywhere command and still cannot make it work. The error is this file is not a database file....

Myron

10-07-2009 01:31 PM
Chris Keating (Sybase iAnywhere)

Hi all, is it possible to use sa_split_list over a table column, i.e. something like select * from sa_split_list((select myListColumn from...

Volker Barth

10-07-2009 04:31 AM
Volker Barth

I have a view, that includes a SELECT-Statement with a union. If I declare the union with UNION ALL, the view works very more performant than if...

Alex Wittler

10-06-2009 02:49 PM
Glenn Paulley [Sybase iAnywhere]

I would like to set up a trigger that updates a field in the row modified with a timestamp. The table (linkitad) looks as follow lktyp...

Claude

10-06-2009 04:03 AM
Claude

I've got a shared library in Ubuntu 7.1.0 that uses gSOAP to make a soap call to a remote server. I am able to call this shared object directly...

David DeRam

10-05-2009 11:51 AM
David DeRam

I'm having trouble creating a function with an external call. I have no problems in Windows but in Ubuntu 7.1.0 (the asa database server...

David DeRam

10-05-2009 11:36 AM
David DeRam

How to install ASA7 database on Win 2000 Virtual server

Deepali

10-05-2009 08:36 AM
Chris Keating (Sybase iAnywhere)

Sybase 9.0.2.3534 What is lock type SPA0000 and could this cause serious issues? Thanks

Herman Miller

10-03-2009 10:17 AM
Glenn Paulley [Sybase iAnywhere]