We have a customer that is interersted in upgrading from ASA 9.0.2 to 11.0.1 (at least we're trying to get them interested). Since we will not be...

Bill Williams

01-12-2010 09:51 AM
Jason Hinsperger

Hi there This is driving me nuts: a database driven planning tool stores intervals (integer) and the date parts (varchar) provided by the user. Now...

Claus

01-12-2010 08:51 AM
Glenn Paulley [Sybase iAnywhere]

There should be no issues running on the Intel Atom Processor. If you do any issues, please report them. -- Joshua Savill Sybase Inc. - Product...

Josh Savill [Sybase]

01-12-2010 08:47 AM
Josh Savill [Sybase]

I'm able to debug a stored procedure with the message-statement in Sybase Central. The messages are displayed in the console window. example: message...

Kevin Saegerman

01-11-2010 12:50 PM
Jeff Albion [Sybase iAnywhere]

I've been experimenting with the x64 version of ASA (10.0.1.3960) and I have been unable to execute external procedures because the server "Could...

Dave Foulkes

01-11-2010 08:40 AM
Dave Foulkes

I need to update a field defined as numeric (6,2) from another field defined as integer within a table. I use the statement like this: Update...

Vanny

01-11-2010 06:48 AM
Vanny

We need to upgrade several 5.5.04 databases to a higher version preferably the latest. We managed to access the data using ISQL V9 but cannot find...

StanGreene

01-08-2010 07:46 AM
Chris Keating (Sybase iAnywhere)

I have problem when Archive/Restore Database file, I use "BACKUP DATABASE TO" for Archive DB and use "RESTORE DATABASE " for restore DB. I archive...

BonWan

01-08-2010 06:01 AM
BonWan

Hi all, I have a table1 with 4 columns: product_id, color, size and quantity. I have as many rows as different combinations of products, colors and...

MGS

01-08-2010 05:46 AM
MGS

Hi everyone - the beta for the next major version of SQL Anywhere, code-named Innsbruck, was just released this past Friday (December 18th). If...

Mike Paola

01-07-2010 11:50 PM
Mike Paola

Hello, I have an encrypted Version 9.02 log file (and corresponding DB file). Is there a way that I can read (in text / sql command format)...

Robert Paresi

01-06-2010 04:19 PM
Glenn Paulley [Sybase iAnywhere]

Val, You're going to need to be more specific about this setup. 1) What version and build of SQL Anywhere (dbsrvX -v) are you running? 2) What is...

Josh Savill [Sybase]

01-06-2010 09:50 AM
Josh Savill [Sybase]

IMHO you should first contact your Sybase sales representative to check if your licence covers the runtime deployment to your customers....

R. Pods

01-06-2010 12:15 AM
Milind Joshi

ivh

01-05-2010 10:09 PM
Chris Keating (Sybase iAnywhere)

Quick help please! When I try to connect to ADO.NET Sample for Windows Mobile 5.0 pocket pc (in VS2008), everything with running SQL Anywhere server,...

QuestionMaker

01-05-2010 11:49 AM
Chris Keating (Sybase iAnywhere)

Hi, I have a peculiar problem. I have a small Java application which uses jConnect 6.0.5 to retrieve some data from an ASA8 database, process it and...

poetix

01-04-2010 11:27 AM
poetix

Is it possible to use db_string_connect() to connect to a DSN source created by SQLite driver? db_string_connect() API is returning sqlcode -103 ....

san

12-28-2009 05:57 AM
san

Hi, We need to bulk insert a lot of records into a table. The table contains a lot of LONG BINARY fields. Usually I can use the LOAD statement, but...

Irving Zhu

12-24-2009 10:38 PM
Irving Zhu

Hi, Is there any way to create a query that joins two tables that reside in two different databases? I use one database to collect raw data and...

Irving Zhu

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

Given the error message, my first guess is that the column is >25 bytes long. You appear to be using the Customers table from the SQL Anywhere 11...

Rob Waywell

12-24-2009 10:52 AM
Nick Elson [Sybase iAnywhere]

Hi all... Getting back into SQL Anywhere after being away awhile, so please forgive the newbie-ish question. I'm wanting to add a unique contraint to...

SQL Antwhere

12-22-2009 03:30 PM
Bob

Hi, How can I execute large SQL files (100 MB size). ISQL is not even able to handle files of 10 MB! I cannot delete the SQL History anymore,...

at

12-22-2009 12:27 PM
Nick Elson [Sybase iAnywhere]

Hi, One server , 2 client pc's. I can only connect from the 2 client pc's when the windows firewall is turned off. How can i still have the...

JVL

12-18-2009 01:59 PM
Chris Keating (Sybase iAnywhere)

Besides...what do you mean "reinstall the 32-bit components". This is a 64-bit OP system, and I downloaded the 64-bit Installation from Sybase and...

ALF

12-18-2009 11:45 AM
Chris Keating (Sybase iAnywhere)

Hello, I need some help. If I run this (in ISQL) or ODBC driver or...

Robert Paresi

12-18-2009 10:09 AM
Chris Keating (Sybase iAnywhere)

Is it necessary to deploy the charsets folder. If so, is it documented in the manual? Thanks Eric

ontsnapt

12-17-2009 04:22 PM
peter

We have a SQLAnywhere10 database running on a Windows 2003 server which has 4 processors and 4GB RAM. There is a complex stored procedure on the...

Aston Cockayne

12-17-2009 10:48 AM
Aston Cockayne

Using Adaptive Server Anywhere 9.0.2.3668. I have a system that has multiple connections to the database that all update records in the...

Paul

12-17-2009 07:17 AM
Glenn Paulley [Sybase iAnywhere]

So there is this SELECT: SELECT * FROM table1 WHERE txtvalue REGEXP '+' AND CAST(txtvalue AS DOUBLE) > 50; basically first it checks if txtvalue is...

nemo

12-17-2009 06:24 AM
nemo

Can somebody tell me how much free disk space is required on the OS (c drive) partition to run the 11.0.1 Build 2352 ebf? I am running into this on...

Jeff Gibson

12-17-2009 03:50 AM
R. Pods

Hi all, I can see from http://www.sybase.com/detail?id=1002288 that Sybase does not support Windows7 with SA 9.0.2 at this stage. My questions...

David MacDonald

12-16-2009 05:39 PM
David MacDonald

I'm having a problem on our Lan where a specific computer cannot connet to the sql anywhere 7 server unless the server computer is rebooted. Once it...

steve wa

12-16-2009 01:00 PM
Justin Willey

Our customer has workstations with windows XP and windows domain users. We have to install ASA7 with administrator account. But, other user on same...

Bofcilo

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

Sudarat, Microsoft has disabled the "Interact With Desktop" feature for services on all of these OSes. This is a Microsoft security limitation. The...

SJ

12-16-2009 10:06 AM
R. Pods

I have an asp.net app that is reporting the following error when loading: Parser Error Message: Could not load file or...

Jack Walton

12-15-2009 03:48 PM
Kory Hodgson (Sybase iAnywhere)

At long last we have decided to upgrade our product database and distributed runtimes to SA11. We have been using the authenticated version of ASA 9...

Seth

12-15-2009 02:13 PM
Seth

A recent experience where a small but persistent and growing disk failure rendered useless over eight weeks of backups has forced me to re-think...

Doug Stone

12-14-2009 09:12 PM
Doug Stone

1) backup database directory 'c:\Monday\' wait before start wait after end transaction log truncate 2) backup database directory 'c:\logs\18\' wait...

Tom Mangano

12-14-2009 06:50 AM
Volker Barth

Hi, I don't know if this is exactly the best group to post this in but it seemed like it. I'm trying to get some validation from some Sybase techs...

Hylon

12-11-2009 07:24 PM
Hylon

Hello, I have installed the sqlany11.msi on Windows 7 and when I go to add a ODBC System DSN SQL Anywhere 11 is not listed as as option. Does...

LHudson

12-11-2009 11:57 AM
Jeff Albion [Sybase iAnywhere]

All, I am testing JasperSoft Business Intelligence Suite, I downloaded the trial version and I am able to run the demo application, my next step in...

Jorge Quintana

12-11-2009 08:17 AM
Jorge Quintana

How to identify what is growing the temp file of a database?

Martin

12-10-2009 04:24 PM
Lucjan Chmura [Sybase iAnywhere]

Can anyone please provide a link for a donwload of an ODBC driver for ASA8? I want to avoid installing the entire product on a specific computer, one...

brillisoft

12-10-2009 09:43 AM
David Kerber

I was creating a new user with only SELECT permission on some tables owned by DBA. If I connect this database using this new user it is possible to...

Heiko Helbig

12-10-2009 09:11 AM
Nick Elson [Sybase iAnywhere]

ODBC driver for SA 10 has check box <<Compress network packets >> Help for this option : Compress network packets Select this option to turn...

Bofcilo

12-09-2009 12:46 PM
Nick Elson [Sybase iAnywhere]

What is the difference between the fire_triggers option at the database level (right-click on the db name then select options then scroll down to...

Jon Owens

12-08-2009 02:53 PM
Jon Owens

SA server version 9.0.2.3456 32-bit, client has 9.0.2.3886 32-bit on win7 x64. I'm using the 32-bit jvm and 32-bit Eclipse for development, so the...

David Kerber

12-08-2009 01:24 PM
David Kerber

hi, i am pretty new in sybase, so excuse if this is a dumb question i dont know why this code does not execute: drop procedure if exists...

José Miguel Loor

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

PROCEDURE : create procedure READER_KS_MAGSTA (IN l_vd char(2), IN l_bd char(10)) begin declare l_kssifra char(13); declare l_id integer; set l_id...

Bofcilo

12-07-2009 03:00 PM
Bofcilo

Greetings, I have a generic query w.r.t to Sybase. Can any one please tell me with example, what is the difference between Sybase Open Server...

test

12-07-2009 02:26 PM
Nick Elson [Sybase iAnywhere]