Index inclusion: an index should not include a other one. Why is this wrong? Thanks Eric

ontsnapt

12-04-2009 07:08 AM
Breck Carter [TeamSybase]

Hi, 100% CPU usage, need to restart DB, how can i find out what causes the Problem? Server...

darkwerks

12-04-2009 07:06 AM
Breck Carter [TeamSybase]

Here is our MobiLink Service Properties: C:\Program Files\SQL Anywhere 11\Bin32\mlsrv11.exe -c...

Rachan Terrell

12-03-2009 05:02 PM
Rachan Terrell

Does any one know how to provide certificated to SQL Anywhere Monitor server when try to connect to mobilink server that use HTTPS? Thanks in...

Rachan Terrell

12-03-2009 05:00 PM
Rachan Terrell

Hi, Would like to know the reason for the behaviour for SA table column created from select into with a variable has not null constraint...

Aparna Kurada

12-03-2009 04:16 PM
Nick Elson [Sybase iAnywhere]

Because iam sick and tired of this next error: "%1 returned a result set with a different schema than expected" , I thought, why not use...

janis

12-03-2009 01:58 PM
Nick Elson [Sybase iAnywhere]

Hello, We run SQL Anywhere 9.0.2.3643 and we get the Database Server connection limit exceeded error when trying to connect to a database network...

Roumiana Valtcheva

12-03-2009 10:38 AM
Nick Elson [Sybase iAnywhere]

Instead of building code from an open record set for output to a CSV file format I am trying to EXECUTE an SQL statement using built in. I just tried...

clayton

12-02-2009 03:18 PM
Rachan Terrell

Hello! We are still having issues with 64-bit SC and not with 32-bit SC when reloading a database. I just need this question answered. Is the...

Robert Paresi

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

Is there a substitute of sp_who2 in ASA7. How can we find out what activity is going on the server..?

Deepali

12-02-2009 01:44 PM
Rachan Terrell

Interactive SQL 9 keeps a persistent command history. Where is this history physically stored?

SalePoint

12-02-2009 12:22 PM
SalePoint

Where can I find the patch to update 9.0.1 for windows x64 to 9.0.2? I can find it for x86 (32-bit), and I can find ebfs for x64 9.0.2 to 9.0.2.x,...

David Kerber

12-02-2009 11:55 AM
David Kerber

We have a customer who started using our pb9/sqla10 product with go-global, a pb-to-the-web citrix work-alike. So, with go-global, we have multiple...

Doug Stone

12-01-2009 05:21 PM
Nick Elson [Sybase iAnywhere]

My current SQL Anywhere version is 11.0.1.2331. When executing the following statement MESSAGE String (oper1, oper2) TYPE STATUS TO CONSOLE DEBUG...

David

12-01-2009 01:52 PM
David

Hi David, I just tried this on 11.0.1.2331: ==== SET OPTION PUBLIC.debug_messages = 'On'; MESSAGE STRING('Hello', ' World') TYPE STATUS TO CONSOLE...

Jeff Albion [Sybase iAnywhere]

12-01-2009 12:51 PM
Jeff Albion [Sybase iAnywhere]

We use SQL Anywhere 11.0 which has been upraded to 11.01 EBF 2341. We installed the InfoMaker from the supplied Development and Design Tools CD that...

Peter Brooks

12-01-2009 10:26 AM
Jeff Albion [Sybase iAnywhere]

Given this MESSAGE statement Use this statement to display a message. Syntax MESSAGE expression, ... [ TO { CONSOLE

David

12-01-2009 09:53 AM
David

SQL Anywhere 11.0.1. Hi all, Is it fair to say that the SQL Anywhere database can be encrypted to AES-256bit encryption and that the Ultralite can...

Shao Chan

12-01-2009 03:37 AM
Shao Chan

I need to find a way to bring up DBISQL in an interactive mode and perform 'start logging' command automatically (as if the user typed it). It's a...

SalePoint

11-30-2009 01:29 PM
SalePoint

Hi, I'm using SQL Anywhere 9.0.2.3546. I do not want "COMMENT TO PRESERVE FORMAT" statements in "reload.sql" created from dbunload because I...

EJ

11-30-2009 11:47 AM
Bruce Hay

Sybase ASA 10.0.1 3903 When you generate the standard msi for install, it will ask the user to choose the directory in which install sybase...

Claude

11-30-2009 10:23 AM
Jeff Albion [Sybase iAnywhere]

I'm trying to create an Entity Data Model with SQL Anywhere 11.0.0.1264 (Personal Server) - part of the PB12 Beta Download. Connection works fine in...

Jim O'Neil

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

Hi, i want to start the db-server in the background. But - because it's a developer edition - I have to accept the licence-agreement by pressing...

11-25-2009 12:08 PM

Hi, validating an ASA 9.0.2 database I get Run time SQL error -- row count in SYSTABLE incorrect. Is there any chance to repair this database?...

Chris Werner

11-25-2009 11:35 AM
Jeff Albion [Sybase iAnywhere]

Hi, I´m trying to start dbeng9.exe on Windows 2003/64 bit on AMD, but I got an error message "dbeng9.exe is valid but for another Computer type"....

Mike

11-24-2009 04:22 PM
Kory Hodgson (Sybase iAnywhere)

This is content of xml file : <?xml version="1.0" standalone="yes"?> <dstSifarnici...

Bofcilo

11-24-2009 02:32 PM
Kory Hodgson (Sybase iAnywhere)

Hello, we actually use SQL Anywhere mostly in java projects. One of our clients however uses PHP as environment and looks into using a php...

André Schild

11-24-2009 12:32 PM
André Schild

Sybase SQL Anywhere 11.0.2 I need to parse the transaction log to extract the Database Auditing records. I have uncovered a painful scenario...

Kyle Danielson

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

Does SQLAnywhere 11.01 support OpenMQ or ApacheMQ providers. If so, we would appreciate some detail on how to setup SQLAnywhere to talk to either of...

Peter Brooks

11-23-2009 06:22 AM
Peter Brooks

Plan caching may be involved. The optimizer compiles a plan without looking at the current values of variables, in some cases this can cause a poor...

Ivan T. Bowman [Sybase iAnywhere]

11-20-2009 04:27 PM
Ivan T. Bowman [Sybase iAnywhere]

This is happening at a customer's site. We installed SQL Anywhere 11 and configure a service to start up automatically. My default...

Lance Douglas

11-20-2009 04:22 PM
Jeff Albion [Sybase iAnywhere]

All visual sybase tools aborts after the initial splash screen. +-----------------+ Current thread: main java.lang.NullPointerException at...

OSteine

11-20-2009 12:40 PM
Jeff Albion [Sybase iAnywhere]

Hi Philip, There are a few ways to control the size of the SA Monitor's stored historical data. On the same page in the web interface where you...

Dan Petker [Sybase iAnywhere]

11-20-2009 09:24 AM
Dan Petker [Sybase iAnywhere]

Hello, Two DELL machines - side by side. Both have Windows 7 installed. One is 32-bit Win7 One is 64-bit Win7 Take a V9.02 Sybase SQL Anywhere...

Robert Paresi

11-19-2009 03:49 PM
Robert Paresi

Also, if it is a problem getting the load file to the server machine, take a look at a new feature in SA11 called client file loading. LOAD TABLE...

David Winkler

11-19-2009 12:58 PM
anil k goel [Sybase]

Hello how could i change the font-size of the sybase-central (all fonts - not only the data-view of tables). thanks in advance & regards Michael

Michael E.

11-19-2009 08:29 AM
Michael E.

I wrote about problem with INSERT .... ON EXISTING UPDATE ... from proxy table. Now, i have same problem with update command update local_table set...

Bofcilo

11-19-2009 08:26 AM
Bofcilo

I installed the evaluation copy of SQL Anywhere 9.0.2 to support my client. I now have a developer license. How do I apply that license to the...

Gurthang99

11-19-2009 04:09 AM
Bofcilo

Hi, could someone help me with execute immediate and the temp table declare local temporary table #temp(name char(20)); execute immediate('my query...

janis

11-19-2009 04:01 AM
Bofcilo

I am using Sybase Central on a Windows 7 x64 machine. When I edit a synchronization model or sometimes when I try to open the model I get an error...

Bret Ferrier (runxc1)

11-18-2009 04:51 PM
Josh Savill [Sybase]

I have two database. One database has proxy table from second database. Select from proxy table work fine. First command is "insert into main_table...

Bofcilo

11-18-2009 04:04 PM
Bofcilo

having trouble running this in windows 7 64 bit it starts and stalls in the same spot windows says rtdsk50.exe has stopped working no matter what...

tim stachelrodt

11-18-2009 03:12 PM
Breck Carter [TeamSybase]

How can we copy a table from one database to another database in ASA 7.

Deepali

11-18-2009 03:06 PM
Breck Carter [TeamSybase]

Our application is built with Microsoft Visual Studio 2005 and SQL Anywhere v8.0.2.4218. We have two tables, part_sec and component_sec, that we...

Mei

11-18-2009 12:41 PM
Bofcilo

Hello, Currently we have a program developed by a third party enterprise and the program uses a Linux server Red Hat 5 and Sybase ASA 7.2 and...

RoninTekorei

11-18-2009 10:27 AM
Nick Elson [Sybase iAnywhere]

After rebuilding my database, when I run reports against the new rebuilt database, the report which was taking 1 hour 40 mins before is now taking...

Deepali

11-18-2009 10:24 AM
Glenn Paulley [Sybase iAnywhere]

I cannot get SQL anywhere to connect to my sybase database Yet other tools, such as dbVisualizer and Aqua Data Studio are connecting

Larry

11-18-2009 09:44 AM
Graeme Perrow [Sybase iAnywhere]

Is there way in SQL Anywhere 11.0.1.2324 to switch off the "result is non-deterministic" message? Perhaps a database option? We have a client...

Phil Harris

11-18-2009 08:56 AM
Phil Harris

Using Microsoft C++ we can query multiple result sets from a single stored procedure call with code similar to this one: CRecordset...

Markus KARG

11-18-2009 06:22 AM
Markus KARG

We are using ASA 11.0.0's Sybase Central tool quite often. Now we noticed that when installing ASA 11.0.1, there is no Sybase Central tool included...

Markus KARG

11-18-2009 06:16 AM
Markus KARG