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

Yesterday 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

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

02-25-2010 07:17 PM
Sohaib Uthmani

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

02-22-2010 10:50 PM
mamcx

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 windows...

shouri.cirigiri@gmail.com

02-11-2010 05:44 PM
shouri.cirigiri@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

Hi All, Some tool which converts ASA/ASE database to MySQL Database vice versa. We have one project requirement; we are looking for some tool...

Jenny

01-27-2010 06:36 AM
Martijn Tonies

Currently, all our application tables are owned by dba. Is this considered good practice? If no, is there an easy way to change ownership of all our...

Doug Stone

01-27-2010 05:16 AM
Breck Carter [TeamSybase]

One of our customers wants to have crystal reports access to our application's database. I think the best path is to setup a read-only user with...

Doug Stone

01-27-2010 03:58 AM
Volker Barth

I have an ASA9 database and get the above error why trying to start it... Does anyone have any ideas on how to recover or repair it. I have already...

Dave

01-26-2010 03:19 PM
Josh Savill [Sybase]

ASA 9/10 armt.40 odbc Hi, we discovered, that in C++ error handling within a sybase function does not work when an error occurs within a...

Fabian Knauf

01-26-2010 12:18 PM
Nick Elson [Sybase iAnywhere]

If I run this: call sa_split_list('AA','\x0d\x0a') I get this result set (which is what I expect) line_num,row_value 1,'AA' If I call this: call...

Clive Collie

01-26-2010 10:58 AM
Bruce Hay

Hello, I have a question about "clustered indexes. After I looked into the documentation, I understand it this way: when using "clustered indexes"...

Ingmar

01-25-2010 01:58 PM
Nick Elson [Sybase iAnywhere]

Our products are still running ASA 8.01 (upgrading to 10 soon). We're aware that ASA 8 .x is no longer supported, but does anyone know if it will...

Al Seltenreich

01-25-2010 12:55 PM
Nick Elson [Sybase iAnywhere]

Anyone have any experience? Tips? Advice? Cautions? Much appreciated, -- -----Jon-----

Jon Springs

01-25-2010 11:25 AM
Roger Holmes

Hi - I wonder if any can advise me on the following issue? I need to run two active databases (e.g. This1.db and This2.db) I want to do an SQL...

Alastair Walker

01-25-2010 07:50 AM
Alastair Walker

We are using Adaptive Server Anywhere 9 for a website coded in ASP.Net (2003). We use services for each database. Each service is set as a "Personal...

S. Male

01-25-2010 07:10 AM
Chris Keating (Sybase iAnywhere)

NewsGroup: sybase.public.powerbuilder.database Date: Jan 24,2010 10:46 pm Created by: Jenny Topic: Some tool which converts ASA/ASE database...

Jenny

01-25-2010 05:19 AM
Jenny

Hi, we are using SQL anywhere 10/11 how can we determine the DB Size for SQL anywhere? I found something similar for MSSQL & mySQL...

Harjo Kompagnie

01-25-2010 12:05 AM
Arthur Hefti

I've been asked to create a backup of a record (which has 75 fields) which can be restored if necessary. I'd hoped to be able to tell if the current...

P Merritt

01-21-2010 12:20 PM
P Merritt

Hi all. I have a ASA server using dbsvr8.exe. The problem: I have configured a service on Sybase Central tool in the Events module on the database....

Jgucani

01-21-2010 06:12 AM
Breck Carter [TeamSybase]

Scenario: Windows XP running Sybase network server as a service under version 10. Installation of version 11.0.1.2044 proceeds with...

Richard Hinder

01-20-2010 05:26 PM
Richard Hinder