Greetings, I am getting a strange error while execution of an sp. Here is the basic flow. Procedure P1--> 1)Create #summary 2)---some business...

test

05-20-2010 02:06 PM
test

Hi, in every function/procedure i write i add this to catch errors: EXCEPTION WHEN OTHERS THEN SET @err = cast(SQLSTATE as TEXT); call...

nemo

05-20-2010 10:34 AM
nemo

Hi, I am having complete SQL Anywhere 11 directory contents with me. I am bundling this as part of my project now I want to know what environment...

Deepak

05-14-2010 06:54 AM
Deepak

Hi, When running SP_SYSMON to try to debug a performance problem, we are getting the following error (which we haven't received before) "Arithmetic...

David C. Watson

05-10-2010 03:36 PM
David C. Watson

This may be an easy one I am pretty new to Sybase. So I open up SQL anywhere and enter my username where prompted. I go to the Database tab and click...

Jackie G.

05-04-2010 01:34 PM
Jackie G.

Hi, We are migrating from version Red Hat version 4 to V5.5.In order to connect to the sybase db we used sqsh at many places but when i try...

MANGLA

04-29-2010 05:11 PM
dantheguy

We are running SQL Anywhere 10.0.1.3415. We have a third-party dll which communicates with our database. It has worked fine for years on XP and...

Steve

04-21-2010 12:48 PM
Steve

Hi, We are planning on creating a new module for an application that, while a part of that application, will be seperate from it for simplicity...

Sohaib Uthmani

04-16-2010 05:12 PM
Sohaib Uthmani

We are using SA10.3976 and try to upgrade two different database file version ASA7 After some time upgrading freeze, Task manager show that scview...

Bofcilo

04-09-2010 10:51 AM
Bofcilo

Hi All I have a simple but annoying problem. Our vendor supplies use with a database with 170 tables. The database is primarily driven from...

Roger Peffers

03-26-2010 08:26 AM
dantheguy

We're about to migrate existing applications from SQLAnywhere 9 to 11. Apps are still in PB9.0.5. We already noticed that indenitty...

chermisha@yahoo.com

03-25-2010 09:23 AM
chermisha@yahoo.com

Our product use SA 10.0.1(3807 Windows; 3805-Linux) , as application server used jboss 4.0.5. Connection to database used jconn3.jar manifest info...

Hanan Brener

03-24-2010 12:23 PM
Hanan Brener

Hello, I'm having a lot of difficulty querying a database. So a little background first. I setup an ODBC connection to the database using...

;lkj

03-23-2010 06:00 PM
;lkj

Hello everybody iam new to .NET and sybase so i need some help on solving the issue.My project is to make web app compatible with vista and windows...

shouri.cirigiri@gmail.com

03-23-2010 10:28 AM
dantheguy

I have a database file (*.db) that need to be recovered. The bad is, the end-user have null idea of the version of the database. Not know the...

mamcx

03-23-2010 10:09 AM
dantheguy

Hi, i have a problem regarding database performance.i am using sql anywhere 8. the size of my db is 5gb and it is pretty slow.inserts, selects, etc....

dev2

03-18-2010 04:13 AM
dev2

Hi, I've seen an update statement affected millions of rows, i have terminated dbsrv process from operationg systems process lists. I have run dbsrv...

keen

03-17-2010 11:27 AM
keen

Hi, I've created a new MobiLink model using the wizard but am running into a problem with the generated After Update triggers...

Steve Sagodi

03-16-2010 03:57 PM
Steve Sagodi

Version: SQL Anywhere 11.0.1.2044 Platform: Mac OS X 10.6.2 I am running into the error 'Unable to load libodbc.dylib' whenever I try to specify a...

Jordan Schroter

03-15-2010 10:47 PM
Jordan Schroter

We use to use 850 with older versions of Sybase but that is no longer an option with Sybase 11. We have about 40 databases that were converted using...

Jonesy

03-11-2010 02:39 AM
tduemesnil

Helllo Can somebody help me with the following. I have a stored procedure likt this example: ALTER PROCEDURE "DBA"."T_Test" (IN gs_test...

Ingmar

03-10-2010 03:32 PM
tduemesnil

Hi, I am currently using Interactive SQL version 11.0.1 to run my select statement against a SQL anywhere 10 database, then use the export menu...

Yong

03-04-2010 02:41 PM
Yong

Hi there, we have issues with programs made in Delphi and using Ado.Net after updating SAS10 version 10.0.1.3835 to 4023 or even the latest...

Igor Hakszer

03-02-2010 06:15 AM
Igor Hakszer

Hello, I have a problem with the server start parameter -gf I want to know if trigger fires, but when I start the server with the option -gf I get...

SM

03-01-2010 07:25 AM
SM

hello i have trouble to install a .net-application with entity-framework and the asa-11.1-client on a new pc (32bit windows-7). i created in the...

Michael E.

02-22-2010 10:57 AM
M.Erlinger

Hopefully a simple one, but I can't find anything obvious in the docs. I want to add a column to my database only if it doesn't exist, as...

blackbird

02-22-2010 02:11 AM
tduemesnil

Hello. We are an OEM and just upgraded from SA8 to 11. We have a problem. Our 4.0 product does reporting with the following stack: DBMS = SQL...

elisokal@gmail.com

02-13-2010 06:45 PM
elisokal@gmail.com

Hello everybody iam new to .NET and sybase so i need some help on solving the issue. My project is to make web app compatible with vista and...

shouri.cirigiri@gmail.com

02-11-2010 05:31 PM
shouri.cirigiri@gmail.com

Our company uses approximately 135 remote databases deployed on Laptop computers. Rarely does a week go by where we do not have at least one or two...

Tim

02-08-2010 05:42 PM
Tim

Do messages such as "1 row(s) affected", "execution time : 0.021 seconds" ever bubble up to the ASA .Net client? I realize I can grab the number of...

Andrew

02-08-2010 02:10 PM
Andrew

Hi. Does "Select top x from y" perform a "full table scan"?

darkwerks

02-03-2010 09:39 AM
darkwerks

I have a data like this col1ID, ExpiryDate,col2ID '000000000001998','2004-05-25 17:19:16.363','000000000000516' '000000000001998','2004-08-11...

Yum

02-03-2010 06:41 AM
tduemesnil

Hi. Does "Select top x from y" a "full table scan"?

darkwerks

02-03-2010 05:03 AM
darkwerks

Hello, I have a very strange behaviour and I need help before asking sybase-support. I have a SQL Anywhere 5.5 Database which I want to migrate to...

Thomas Auer

01-29-2010 06:15 AM
Thomas Auer

SQL Anywhere database error : "assertion failed 101412". I tried deleting log, rebuild database, validate database, but all failed !! and last backup...

Ahmed A.

01-29-2010 05:57 AM
Bofcilo

Hi, I need to move Sql Anywhere 9, 10 user from Server to a new server. How do I get the registration/license information off of the...

TravellingMan

01-28-2010 05:52 PM
TravellingMan

We have 6 servers that have the same configurations. Each server runs 16 instances of the same application to access databases. Dbsvr8 is setup as a...

Ivan

01-28-2010 12:44 PM
Ivan

We are running SQL Anywhere 10, version 10.0.1.3722 on a Windows 7 machine. Everything looks fine except that we can't access the ODBC Administrator...

Jon Owens

01-28-2010 10:53 AM
Josh Savill [Sybase]

I get the following error when trying to unload a database from Sybase 9 to 11 using the "-an" flag: ***** SQL error: Item 'sa_recompile_views'...

Jonesy

01-28-2010 09:52 AM
Bruce Hay

Hello, I'm using Delphi 2007 with AnyDAC-Components (http://www.remobjects.com/) and I access SQL Anywhere 11. What does it mean, if i see in SQL...

Thomas Auer

01-28-2010 09:26 AM
Thomas Auer

Hi, I've got a Windows form Form1 with a button button1 and the code below. The OleDb fillschema doesn't seem to work. ASA 11.0.0.1549 using...

Mark Libbrecht

01-28-2010 06:57 AM
Mark Libbrecht

Hi, I would like to write a before update trigger that will check the value of a column and if the value is satisfied, I would like to stop the...

a.sahan

01-28-2010 06:41 AM
a.sahan

I have a little situation where we need to have two installations of a canned app (that runs on sql anywhere 10) and the two installations can't talk...

Bomee Jung

01-27-2010 05:32 PM
Bomee Jung

Any suggestions as to how to go about fixing this? I'm running dbisql.exe ver 9.0.2.3886 32-bit (which is supposed to be Win7 compatible) against a...

David Kerber

01-27-2010 04:19 PM
David Kerber

Hello, I see very frequent crashes of dbsrv11 on Windows 7 32 Bit (11.0.1.2355) and on Linux (Debian 64Bit 11.0.1.2324) when profiling is turned...

André Schild

01-27-2010 12:34 PM
André Schild

I'm using ASA 9. I'd like to do the following, and would like an example of how to name each database: SELECT INTO "ARCHIVE_DB"."Table" FROM...

S. Male

01-27-2010 12:13 PM
Karim Khamis [Sybase iAnywhere]

Is anyone aware of a unit testing framework for SQL Anywhere stored procedures (in particular for SQL Anywhere 9.0.2)? I have been looking at TSQL...

Philip Harris

01-27-2010 12:03 PM
Philip Harris

Just came across this and wondering if it's a known issue. ASA 8.0.3.5267 on Windows Server 2003 R2 32 bit. Machine has 4GB or more RAM. Database...

Bob Leviton

01-27-2010 11:22 AM
John Smirnios [Sybase]

Hi, In I-Sql there is the option Data/Import which makes it possible to load data into a table from a csv file. If for example the csv file would...

Christian Hamers

01-27-2010 10:14 AM
Volker Barth

I'm using Adaptive Server Anywhere 9. The database holds results from inspections. We'd like the 'running' database to hold only a certain amount...

S. Male

01-27-2010 09:09 AM
S. Male