ASA 9.0.2.3288 I have the following soap service definition which creates the .net Dataset when called from my C# application. create service...

Scott Holman

05-22-2006 12:44 PM
Scott Holman

hello, can anyone please help me solve or direct me in solving this strange behaviour. We have now had 3 occassions on 3 different windows...

AT

05-22-2006 12:13 PM
AT

I am kind of new to this but i am trying to backup my databases while they are still runnning. Now i did get it to work using dbbackup but it only...

AT

05-22-2006 12:07 PM
AT

Hi, I've a table in my ASA 8.03 database which has two fields "object_id" - double and "datum" - date. The application is a reservation system,...

Martin Müller

05-22-2006 12:06 PM
anil k goel

I have a ASA8 table accessed by an Access 2003 front-end. The primary key is a standard (not global) autoincrement (integer). However, I get the...

Darryl

05-22-2006 11:29 AM
Darryl

Hi I have created an event which executes a stored procedure to do a backup. When the event is triggered it gives the following error on the...

Paul Rowe

05-22-2006 07:16 AM
Paul Rowe

Hello. I have a column of type long varchar which contains a RTF-String. Now, is there a possibility to convert this RTF-String to plain-text...

Thomas Kehl

05-22-2006 05:28 AM
Justin Willey

Hi, I have a BEFORE INSERT,UPDATE,DELETE trigger that prevents changes if transactions are posted. This works fine. I need to allow changes under...

Edgard L. Riba

05-21-2006 06:52 AM
Breck Carter [Team iAnywhere]

Database: Sybase Adaptive AnyWhere 9.02 VS 2003 DOT.NET Framework 1.1 Using ODBC as database-interface Sometimes I get LOCKS on a table, after I...

Peter Stojkovic

05-21-2006 06:51 AM
Breck Carter [Team iAnywhere]

ASA 9.0.2.3044 I have created an insert/update stored procedure. This procedure will insert or update rows on multiple tables. Most of the columns...

Jim Blackburn

05-20-2006 06:58 PM
Jim Blackburn

Does anybody know how to get the version of Sybase that is running on the client machine. I know that @@version will return the version of the...

Scott Bogash

05-20-2006 09:16 AM
Ian McHardy

Any docs (white papers, comparisions) between ASA and mySQL. Performance benchmarks and the good stuff ? With mySQL 5.0 does seem to be making a...

handheldmaster

05-19-2006 08:27 PM
Steve M

Hi all, I am backing up daily with a Pearl script the DB and the log file, but the log file is getting very big. Do i need to back up the log...

AT

05-19-2006 01:22 PM
AT

asa9.0.2.3274 running on windowsxpsp2 dbsrv9 crashed logged a windows message error. Get a message the instruction at '0x0050ddce' referenced memory...

handheldmaster

05-19-2006 10:00 AM

If you have joined the SQL Anywhere 10 beta program, be sure to join us for a special roundtable discussion with experts who will be answering...

Mike Paola

05-19-2006 09:56 AM
Mike Paola

Hi I've just upgraded and app from SQL CE 2.0 to SQL Mobile. All was going well, (or so I thought) If I run the following bit of SQL into a...

IceVan

05-19-2006 08:56 AM
IceVan

Hello, In one database, of a customer of ours, a proxy table has disappeared mysteriously. In our software the users have no capability to perform...

Harry Schurink

05-19-2006 06:24 AM
Harry Schurink

Hi, I know about 'sa_conn_info' but how can i get a list of users that are logged into the DB. I am using Powerbuilder as the frontend App and...

Stephen

05-18-2006 10:29 AM
Paul Horan[TeamSybase]

ASA 9.0.2.3228 Is there a simple way to log all error messages in a procedure or trigger e.g. to a seperate table? Something similar to the audit...

Klaus P. Pieper

05-18-2006 01:33 AM
Klaus P. Pieper

I have a trigger after update where I am dynamically trying to get the values of the updated columns comparing them and inserting them into a log,...

Ravi

05-17-2006 04:52 PM
Nick Elson

Where can I download an OLE DB provider or an ODBC drive that will let me connect to an ASA 7 database? I have not had any luck finding either on the...

Bill

05-17-2006 02:51 PM
Paul Horan[TeamSybase]

Hi, I had posted a previous message, but decided to delete it because it was so big. Sorry for those that got to it before I could delete...

Edgard L. Riba

05-17-2006 12:03 PM
Reg Domaratzki \(iAnywhere Solutions\)

I am a newbie just developed a simple app on my destop with pb 9.0 and sql anywhere 9.0. I have a little net work and I will to connect to the db on...

John

05-17-2006 10:45 AM
Chris Keating(iAnywhere Solutions)

My Sybase Central is very slow, any ideas? 1) By slow I mean, each click takes 40 to 90 seconds. 2) None of my db call are slow, just Sybase...

Craig

05-17-2006 10:24 AM
P Merritt

Moving from ASA 8.02 to 9.0.2 EBF 3267, we get the different result-set, when using "select first ..." in a very simple correlated query: create...

Yasha

05-17-2006 10:22 AM
Yasha

I have failed at getting ASA OleDB to work correctly on the client. The code works on the development machine but does not work on a...

Jim Rand

05-17-2006 08:31 AM
Chris Pienta

Hi, I'm trying to write a stored procedure (sybase) to empty out a synchronization subscription but I'm having problems. In a general sence the...

Tom Hughes

05-17-2006 06:49 AM
Reg Domaratzki

Just a note to tell you how great your database is working for us. We are developing a web application using an archectecture which includes...

James Diaz

05-16-2006 04:34 PM
James Diaz

Hi How do I get a stored proc to return an 'output' parameter value? I have created 2 stored procedures, one of which is called by the other. The...

Paul Rowe

05-16-2006 11:12 AM
Bruce Hay

Hello, If I use HEX-FA (200) then it seems to work properly. Not sure why the system is unable to make a proper selection, it is the DEFAULT...

Robert Paresi

05-16-2006 11:06 AM
Nick Elson

I've created an external login in an ASA db pointing to a DSN to the backend database. The password to the backend database is stored with this...

Bob

05-16-2006 09:13 AM
Bob

Hi, I have ASA 8 with a PB application that runs a Backoffice System. I now have users that need to access this DB from a remote site and i...

Stephen

05-16-2006 08:28 AM
David Kerber

Hi, I am running Lexware finanacial office pro and I am getting the follwowing error messgage: NativeError: -84 SQL-Error: '08001' State: 08001;...

Adaptive Server Anywhere Native Error: -84 with Lexware

05-16-2006 07:45 AM
Chris Keating(iAnywhere Solutions)

Hi, My server (9.0.2.3267) fail with "Assertion 202101: Invalid bitmap links on page 0x10002aeb. If I restart the server - same problem. As I can...

Michael Kany

05-16-2006 07:24 AM
Chris Keating(iAnywhere Solutions)

Hello, I don't understand the EBF HTML and always wanted to see it in VERSION BUILD order, not products. Meaning, I know that I am at EBF Build...

Robert Paresi

05-15-2006 10:04 PM
Andrew Giulinn

Is creating a parameterized SQL query using the SqlDataSource class in ASP.NET 2.0 supported? Is there any documentation on how to do this?

Metal2You

05-15-2006 02:30 PM
Metal2You

Hi, I've been having crashes in a 9.0.2.3274 server running on a Dell 2850 server, with Win 2003 enterprise and 2GB o memory. The most recurring...

Edgard L. Riba

05-15-2006 11:59 AM
Edgard L. Riba

Would someone be so kind as to indicate how an SQL Anywhere 9 bug should be reported. Thanks. Mark Shapiro

Mark Shapiro

05-15-2006 11:54 AM
Mark Shapiro

Hello when we use DataBaseMetaData.getColumns() on columns which belong to a table that has CLOB or BLOB columns, getColumns() is very, very slow....

AT

05-15-2006 11:14 AM
Nick Elson

I all, I'm a lot troubled... I've tried to start a query using the same (binary) asa db started on the following engines: - ASA 9.0.1(1753) on...

Nicola Cisternino

05-15-2006 10:52 AM
Nick Elson

One of our customer's workstations is often being disconnected from their asa 9.x. Does the text below give any indication about what might be...

Doug Stone

05-15-2006 10:22 AM
Reimer Pods

Hello, I originally installed 9.01 on my developer machine, and I have been applying all EBF's. However, my documentation still shows as 9.01 - ...

Robert Paresi

05-15-2006 09:14 AM
Robert Paresi

Problem PB10 with Sybase ASA 6.0 I have tables with not null column and default values in ASA 6.0 DB. While doing transaction with the these set...

Shweta

05-15-2006 01:00 AM
Shweta

Problem PB10 with Sybase ASA 6.0 I have tables with not null column and default values in ASA 6.0 DB. While doing transaction with the these set...

Shweta

05-15-2006 12:59 AM
Shweta

Once an event is created which db connection do they run on/under ? Example: If the event seems to be looping how-to terminate its current execution...

handheldmaster

05-14-2006 07:55 AM
Hanan Brener

Hi, hope everybody is fine, i have a problem in my action page. i really had a hard time tracing this problem. this problem is about...

john

05-14-2006 07:22 AM
Martin Baur

Hello... Database: Sybase SQL Anywhere v5.5 Programming Tool: Powerbuilder 7.0 I have a stored procedure which test for the creates and populates...

Alex Castillo

05-13-2006 06:56 AM
Breck Carter [Team iAnywhere]

I have several versions of a corrupt database. The latest DB file which passes both DBVALID and DBUNLOAD is about one year old. I am now trying to...

Klaus P. Pieper

05-12-2006 12:52 PM
Greg Fenton

Can anyone help me determine why I can not start a DB server with ECC Encryption? I am attempting to start a database server so that it will only...

svanessen

05-12-2006 11:30 AM
Graeme Perrow

Hi, we must export inside VS.2003 data from ASA 9.02 into in EXCEl-File ( XLS ) With several sheets. We can make a connection to ASA 90 via ODBC or...

Peter Stojkovic

05-12-2006 11:29 AM
Mike Gould