The fact that the report runs fine from PB and ISQL makes me wonder what could be wrong when connecting with JConnect. It seems unlikely that...

Nick Elson [Sybase iAnywhere]

11-17-2009 06:11 PM
Nick Elson [Sybase iAnywhere]

Hi, i currently use ASA 11.0.1.2222 and ORA 10.2. I created a Proxytable via ODBC in ASA to retrieve data from ORA. If I select data from...

Benjamin Kemner

11-17-2009 02:25 PM
Nick Elson [Sybase iAnywhere]

Hello, on connect to the database Assertion Error 101506 (10.0.1.3976) allocation size too large when reallocating memory. What ca i do? By

Lars Kohlhagen

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

Hi, on a PDA HP iPAQ 214 I get fatal errors and abnormal connection termination. See the console log attached. This is a ASA 9.0.2 3654 database...

Chris Werner

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

How can I ensure that users can connect to the rebuilt database that has the same name as that of the old database.

Deepali

11-17-2009 06:01 AM
Breck Carter [TeamSybase]

All: Here is a good opportunity for the Sybase community to have a Python framework that works for them and eases development. Web2Py...

Aniruddha Khole

11-17-2009 12:47 AM
Aniruddha Khole

Until yesterday, I have been running Sql Anywhere 10 and 11 (developer's version). I decided it was time to dump 10 so I uninstalled it. ...

Austin Drum

11-16-2009 08:13 PM
Nick Elson [Sybase iAnywhere]

I have a stored procedure that outputs 341 rows if using the syntax: SELECT * FROM...

Seth

11-16-2009 05:14 PM
Seth

How can I ensure that a checkpoint has occurred and committed transactions are written to the database. If I stop the database service and take a...

Deepali

11-16-2009 04:42 AM
Deepali

I was trying to install SQL Anywhere 11 on my Vista and while the installation tried to create the sample databases it was 'stuck' at the 'starting...

theonaki

11-16-2009 02:32 AM
Maria

I am getting an error: cannot convert I to numeric(30, 6) while rebuilding. I don't have any clue how to solve this. Thanks , Deepali

Deepali

11-13-2009 10:08 AM
Deepali

Is it possible to issue an update command that does not write the transaction log? Phil Harris SQL Anywhere 9.0.2.2451

Phil

11-13-2009 09:46 AM
Breck Carter [TeamSybase]

Hello all. I have a client with a SQL Anywhere 5.5 DB file that is used by a proprietary application. The vendor no longer supports the...

David

11-13-2009 05:15 AM
Dmitri

Hi all, We currently have the following scenario: <DBMLSync> <Mobilink Sync> The Oracle database hosts the main application and the ASA...

Shao Chan

11-13-2009 04:51 AM
Shao Chan

Hello, How do I report this and where so it is resolved? -Robert "Robert Paresi" <firstname (AT) lastname (DOT) net> wrote

Robert Paresi

11-12-2009 02:58 PM
Robert Paresi

While rebuilding, why is it that the process gives an error for 'a table not found' whereas a view exists with the same name in the step creating...

Deepali

11-12-2009 02:36 PM
Jeff Albion [Sybase iAnywhere]

We are using SA10 on Vista 64 PC with CPU 4 core. For one stored procedure, Vista performance monitor show that only one core (logical processor) is...

Bofcilo

11-12-2009 12:25 PM
André Schild

Is there a command to start and stop a Sybase service at a specific time each day?

Jon Owens

11-12-2009 11:10 AM
Jon Owens

Hi , I'am trying to create a query with dynamic columns: ALTER PROCEDURE "DBA"."DynamicTest"( in col varchar(50) ) BEGIN declare @str...

janis

11-12-2009 09:07 AM
Reg Domaratzki [Sybase iAnywhere]

I am getting the dreaded: *** ERROR *** Assertion failed: 201129 (9.0.2.3439) File is shorter than expected I can't get a service to even start on...

NoWayJose

11-11-2009 01:07 PM
NoWayJose

A customer was reporting assertion failed errors. I found two tables with problems. One table, schedules, seemed to have index related (or based)...

Doug Stone

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

Would it be possible for dbunload to continue unloading a table when it encounters errors? For example, dbunload would encounter an error situation,...

Doug Stone

11-10-2009 09:49 AM
Doug Stone

Hi!! I have a table with no unique ID, I created an Id with ROW_NUMBER () OVER (ORDER BY column asc) rank and created a stored procedure with the...

janis

11-10-2009 09:43 AM
Glenn Paulley [Sybase iAnywhere]

We have a customer where it looks like their database and all their backups are corrupt. I am seeing a "checksum failure on page 11661" error when...

Doug Stone

11-10-2009 09:41 AM
Doug Stone

SQL Anywhere Network Server Version 11.0.1.2044 (64 bit) installed on Windows 2008 server standard sp1 (64 bit) crashes without rhyme or reason. ...

Tom Mangano

11-09-2009 05:02 PM
Tom Mangano

not sure if this is the group to ask. I setup the ado entity model for my own database in visual basic studio 2009 standard like the...

gg

11-09-2009 04:46 PM
gg

Hi, For 9.x and 11.x --- isn't there a registry hack to stop the INTRO (PURPLE) screen to stop appearing when going into SCJVIEW? -Robert

Robert Paresi

11-09-2009 03:23 PM
Robert Paresi

While rebuilding ASA7 database, I am getting an error in the step, 'creating views.' Error is: "SQL Error:Table 'Tkt_VW' not found." But when I run...

Deepali

11-09-2009 08:21 AM
Chris Keating (Sybase iAnywhere)

Hi, I'm working in Sybase 9.0.2.2451 I'm new in Sybase and I'm trying to create a dynamic where clause in a stored procedure. This is my...

janis

11-09-2009 05:47 AM
Krisztián Pintér

Hi, i wann to use the odbc-driver to connect to the database-server on several clients. Also on 1 client i want to use several tools (sybase...

11-09-2009 03:46 AM
Volker Barth

After installing and re-installing the developer edition of Anywhere 11, the help files still cannot be found. I set the value of SQLPATH=C:\Program...

jhanin

11-08-2009 05:41 AM
Breck Carter [TeamSybase]

How do I get Sa 11 LINQ template to show in VB.net studio 2008? the vb.net studio 2008 build is 91351-136-0866503-60460 I am using SA 11.0.1.2250d...

gg

11-07-2009 12:08 PM
gg

Accourding to the crash log you are using 10.0.1 GA, it would probably be a good first step to try upgrading to the latest EBF for 10.0.1 and see if...

Kory Hodgson (Sybase iAnywhere)

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

Hello all, I am getting the following error above, but all my logs starting and ending offsets are okay and the only thing from Sybase talks...

Nick

11-06-2009 03:07 PM
Nick

Sybase 9.0.2.3534 Does this version of SQL Anywhere and Mobilink run on Windows 7? Thanks

Herman Miller

11-06-2009 11:10 AM
Chris Keating (Sybase iAnywhere)

when i run dbserv8 on the handheld, i browse for a database this brings up a dialog box Folder is set to "All Folders" Type is set to "Databases...

Roshintosh

11-06-2009 06:29 AM
Roshintosh

We have a server running SQL Anywhere 10. An audit we had didn't like the server responding to ping on port 2638. Is it possible to disable the...

Jnorton

11-05-2009 01:20 PM
Josh Savill [Sybase]

On Windows Server 2003 R2 SP2 with latest security patches we installed SQL Anywhere 11.0.1.2276. dbsrv11.exe was installed as a windows network...

Markus KARG

11-05-2009 07:56 AM
Markus KARG

Hi, we are using SQL Anywhere 11. When we use interactive sql for exporting data from a table to a csv-file, we don't see the column header. Is...

Filip Vanderstappen

11-05-2009 03:58 AM
R. Pods

how to create a table from a view in ASA7 database.

Deepali

11-04-2009 08:06 PM
Nick Elson [Sybase iAnywhere]

I understand the default connections in SQL ANYWHERE 9 is 5 , how do I set the MAX CONN to 0 which means unlimited connections. Recently the DB in...

RISI

11-04-2009 10:33 AM
Josh Savill [Sybase]

How can I use REGEXP to REPLACE characters in a string? Lets assume I have a string like this: 'abc xyz 123 879-890' and I want to remove...

at

11-03-2009 02:07 PM
at

We get this message: A query has been running longer than the 10 s threshold. A query issued by connection 'Apply' (ID 2,916) has been running for...

Brian

11-03-2009 10:40 AM
Brian

I posted this question in the ultralite forum but have not received any responses. This forum seems more active and I need an answer, please! I...

Paula

11-03-2009 09:55 AM
Paula

All: Here is a good opportunity for Sybase developers to have a Python framework that works for them and eases development time. Presently, the...

cesmiga

11-03-2009 04:24 AM
Richard Biffl

Hello, As part of PA-DSS (Payment Application-Data Security Standard) compliance, we are required to log every time someone accesses a...

SalePoint

11-02-2009 05:30 PM
SalePoint

My question is, how is the optimizer estimating that 300.000 Diskreads will result in 1278 seconds runtime compared to 1 Mio Diskreads which will...

Martin

11-02-2009 02:11 PM
Glenn Paulley [Sybase iAnywhere]

Hello, Changing the name of a table from "Reports" to "REPORTS" says it can't be done because table already exists. Workaround is to rename it to...

Robert Paresi

11-02-2009 01:05 PM
Glenn Paulley [Sybase iAnywhere]

Hi all, I would like to know if several different data bases running at the same time in a single server engine may degrade performance compared to...

Mgs

11-02-2009 11:08 AM
Breck Carter [TeamSybase]

Is it possible to connect to an oracle database from a trigger in ASA9? I can also use newer versions of ASA if needed.

Jan Erik

11-02-2009 07:41 AM
Volker Barth