SQL Anywhere 9 and 10 sample code files are marked with notices like this: // ******************************************************************* //...

Breck Carter [Team iAnywhere]

11-05-2007 02:21 PM
Chris Kleisath

Manually running a dbbackup command on a computer with SQL Anywhere V10.0.1 causes the web server to stop working with the database server. We...

Bob Piskac

11-05-2007 08:52 AM
Bob Piskac

We are running ASA 9.0.2.3058 on a Windows 2003 Server. All access is via a Win32 application running on 4 Citrix servers running Citrix...

Michael Gould

11-04-2007 07:11 AM
Michael Gould

Hello. I am looking for advice. We started out running ASA8's dbsrv8 as a Windows service running within the so-called "Local System account." ...

Eli

11-03-2007 12:49 PM
Eli

Is there an ODBC driver available that would allow access to a Watcom SQL 3.2e database? Thanks, Dan

Dan

11-02-2007 04:40 PM
Dan

I am using ASA 9.01 and 9.02 with a Delphi 7 client/server application, ASTA middleware, and ODBCExpress dataset components. In ASA 9.01, the...

Mark

11-02-2007 08:54 AM
Bruce Hay

On a Vista workstation I've tried to update the ODBC setting from an existing Access 97 database that was previously linked to the old iAnywhere...

Sharon K

11-02-2007 08:19 AM
Sharon K

Hello I would appreciate a little advice here. I am running SQL Anywhere 9 as a service it was running quite happily until @ 14:00 yesterday the...

Tony Caddick

11-02-2007 08:08 AM
John Smirnios

MD, If you do not tell it explicitely not to do so, SQL Anywhere tries to be nice and give resources to other applications that might run on the...

Frank Ploessel

11-01-2007 02:27 PM
John Smirnios

Hi all...We have Sybase Central 4.3.0. Once I connect to my DB there are folders for Tables, Views, Indexes, Triggers, etc... So far so good. My...

Mark

10-31-2007 04:11 PM
Andrew Giulinn

I'm a bit confused by something though. Your chart on this page (http://www.ianywhere.com/products/supported_platforms.html)indicates that all of the...

Jon Owens

10-31-2007 01:13 PM
John Smirnios

On one of our key ASA 9.0.2 databse ,we want to perform DBUnload and reload operation. The steps we outlined are as follows - 1) Make sure there...

MD

10-31-2007 10:54 AM
MD

We currently run ASA9.0.2.3137 and are considering upgrading. Is there a document that details the major changes from ASA9 to ASA 10? Also, is...

Jon Owens

10-31-2007 08:39 AM
Caleb Woodford

I have a PB app using SQLAnywhere 10. The app runs fine in development and fine from the executable on the development machine. When I deploy it to...

Robb Marr

10-30-2007 12:46 PM
Robb Marr

Just wondering if anyone could give me a hint how could I install iAnywhere ODBC client component and automate the ODBC configuration. I mean I have...

Wndr

10-30-2007 12:11 PM
Wndr

One of our customers was reporting various problems with our application. I decided to unload and reload their database. dbunload using "primary key...

Doug Stone

10-30-2007 09:07 AM
Paul Horan[TeamSybase]

I am running Windows 2003 Server with both 8.03 and 9.02 installed. I have two services installed (called 8Sybase and 9Sybase) The parameters are...

Dustin Bird

10-30-2007 07:31 AM
Dustin Bird

Hi, how can i identify the SQL Anywhere Version with patchlevel, product, licencetype, ... and things like that per sql query. regards, TiCar

TiCar

10-30-2007 04:35 AM
Breck Carter [Team iAnywhere]

SQL Anywhere 10.0.1.3488 It seems like this is not being evaluated before being sent to ODBC...or something: select uuidtostr(newid()) To see why...

Spencer Wasden

10-30-2007 04:28 AM
Breck Carter [Team iAnywhere]

All, Given the situation that I have an SQL file with multiple queries, does Sybase provide a way to parse that file and execute each of the queries...

dpillay.lists@gmail.com

10-29-2007 05:07 PM
Andrew Giulinn

I have installed SQLAnywhere10 on an Intel iMac but have not been able to create a database. I keep getting the following error: Could not connect...

wasabi

10-29-2007 11:14 AM
wasabi

Hi All, I am using Sybase development kit to develop an application which uses Sql Anywhere as the database. The issue is when i exit from the Server...

Puneet Makwana

10-29-2007 09:17 AM
Paul Horan[TeamSybase]

Hello all, I am facing a problem when running the following function: alter FUNCTION rowtocol( IN qry varchar(4000),p_dlmtr varchar(10) DEFAULT...

Pradeep

10-29-2007 08:20 AM
Pradeep

Hello, I'm doing tests for Upgrading our SQL Anywhere 9-DB to Version 10. With the latest version 10.0.01 (3415), I too a Backup from our...

Thomas Auer

10-29-2007 02:53 AM
Thomas Auer

My application is crashing and it looks like ASA is the problem The problem is when I close certain windows the app will crash and report that...

MattN

10-26-2007 02:43 PM
Breck Carter [Team iAnywhere]

From looking at the plan fragment you have posted, I agree that the scan of the small table is not doing 64K group reads. Instead, each table page...

Ivan T. Bowman

10-26-2007 02:10 PM
Frank Ploessel

Try adding a space: exec ('grant dba to '||@appo) On 25 Oct 2007 09:48:43 -0700, mauro compagnoni wrote: -- Breck Carter RisingRoad SQL Anywhere...

Breck Carter [Team iAnywhere]

10-26-2007 08:36 AM
Breck Carter [Team iAnywhere]

When I go to start - programs - sql anywhere 10. i don't have Online books. How do I get that? V 10.0.1.3515

Brett

10-26-2007 07:09 AM
Shuchit

A past post said: "as long as they have different server names, 2 instances of dbsrv50 can run on the same machine" I have not been able to get...

Mike

10-26-2007 12:22 AM
Mike

I've spent four hours on this and can't figure it out. I had no problems when my network consisted of all Win98 machines. When I added a WinXP...

Mike

10-26-2007 12:03 AM
Mike

Hi, When I discussed a case this morning where we need a kind of least common multiple of some values, I came to realize that nearly no relational...

Frank Ploessel

10-25-2007 04:42 PM
Glenn Paulley

hi, i have a problem in executing a command. i want to grant administrator rights to another user, but i have to select it in a table. this is my...

mauro compagnoni

10-25-2007 12:48 PM
mauro compagnoni

I have ASA 9.0.2 server and I have redirected the server error log from DBConsole to a log file (using -o option during server startup). I see that...

MD

10-25-2007 12:28 PM
Breck Carter [Team iAnywhere]

Hello all, My team is trying to use the iAnywhere.Sybase.Asaclient (middle part might be spelled incorrect) in our C# project with a...

JC

10-25-2007 12:14 PM
Nick Elson

Right now one have to SAxxxx etc instead of generic objects if there is factory provide, one could easily replace ms sql server or even Oracle with...

gg

10-25-2007 12:03 PM
Nick Elson

I am trying to run a SQL Anywhere 10 as a Windows Service. This was working for a while and now (after numerous service adds and deletes) it is not....

Jason Grundy

10-25-2007 08:57 AM
Chris Keating (Sybase iAnywhere)

Is it possible to run SQL Advantage when only ASE 15.0.2 Open Client is installed. I really hate ISQL...

D. Nevill

10-25-2007 02:34 AM
Paul Slater

Hi, I've been consuming web services with ASA 9.0.2.3267+ for several years now. One of the sites that I do business with had their certificate...

JR

10-24-2007 03:26 PM
JR

Serbus, the JRE142_13 installation throws the following error: "A valid installation of Adaptive Server Anywhere 9 could not be found. Setup will...

Pavel Karady

10-24-2007 12:51 PM
Pavel Karady

I have an ASA 7 DB that I need to build some new indexes on for some large tables. The company is open 24x7 so the DB is never taken down. Can I...

kam

10-24-2007 11:14 AM
Nick Elson

Hi, Is there any utility out there that act like the Profiler in SQL Server for SQL Anywhere? I need to capture the query done by a Powerbuilder...

leeaikmeng@gmail.com

10-24-2007 06:33 AM
Breck Carter [Team iAnywhere]

Hello, We're using ASA 9.0.2.3557. We have 2300 remote databases synchronizing to an Oracle consolidated. If a table with an autoincrement column...

Andy

10-24-2007 06:30 AM
Breck Carter [Team iAnywhere]

I have an SQL Anywhere 10.0.1.3559 database that is using Java JAR files I've created in some database functions. These JAR files are using external...

converge

10-23-2007 02:25 PM
converge

We want to be able to support different time zones for different databases running on the same windows server. We use the dblib interface to connect...

Steve Garland [ASTA]

10-23-2007 01:44 PM
Bruce Hay

Hi, I haved followed the article at http://www.sybase.com/detail?id=47920 and have successfully created and used the described responsefile....

Ottar Holstad

10-23-2007 03:03 AM
Ottar Holstad

Hi We want to move our SQLAnywhere database to a new server. We have a 25 user SQLAnywhere license. Does anyone know the minimum number of microsoft...

tony walsh

10-22-2007 09:09 PM
Chris Keating (Sybase iAnywhere)

Hello, I need to know which TCP/IP ports are used by Adaptive Server Anywhere 7 since we moved the server to a machine behind a firewall. Please...

litevsky@gmail.com

10-22-2007 01:25 PM
Stephen Rice

Hi, I am trying to connect to a network database server in my embedded SQL code using a DSN. Just before I do the CONNECT statement, I try to find...

V Jain

10-22-2007 01:12 PM
V Jain

I have a Java JAR file that accesses a USB device. Using a function call in the database, I am able to successfully execute code from the Java JAR...

converge

10-22-2007 11:03 AM
converge

I noticed that if I have a service running multiple databases sa_conn_info() will show me the users connected to all the databases (not just the one...

David DeRam

10-20-2007 09:41 AM
Paul Horan[TeamSybase]