I have a vague recollection that we had problems with the storage card in the emulator because it doesn't generate a unique identifier for each file...

John Smirnios [Sybase]

04-20-2009 12:26 PM
John Smirnios [Sybase]

Database move strategies I need to move a database to a different data center... and any input from the group on how to do it is more than welcome! ...

Ron H

04-20-2009 09:40 AM
Reg Domaratzki [Sybase iAnywhere]

Hi all, Some users of our system wish to be able to connect to the SQL Anywhere database and query it. I understand that the ODBC drivers can be...

Shao Chan

04-18-2009 12:04 PM
Shao Chan

hi all. i have a problem, my service is up but i can't make a select into my database , when i see the log of service show me: .. 04/16 16:48:57....

ivh

04-17-2009 12:02 PM
Jeff Albion [Sybase iAnywhere]

Hello Everyone, I'm trying to find out why the .DB file size reduces when the database is stopped or when the service that runs the database is...

Tejonath

04-17-2009 11:59 AM
Glenn Paulley [Sybase iAnywhere]

How can I get the current file size of a database through Sybase? I see that there is a file size property but that value doesn't seem to correspond...

Jon Owens

04-17-2009 11:53 AM
Jon Owens

Hello all: I manage a small office network that uses an application that relies on an application with Advantage Database Server 8.10.0.18 for...

Mike

04-17-2009 08:43 AM
J.D.

Hi I'm building a set of stored procedures for Sybase IQ 12.6/12.7 for extracting of database structure as DDL statements. These stored procedures...

Leonid Gvirtz

04-17-2009 06:55 AM
anil k goel [Sybase]

I found a problem where the database seems to hang and not accept any connections or login’s. The connection just hangs and the database seems to be...

Marvin

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

For performance reasons, it is highly recommended that DEFAULT AUTOINCREMENT only be used with columns defined as a PRIMARY KEY or with a...

Rachan Terrell

04-16-2009 08:57 AM
Nick Elson [Sybase iAnywhere]

Running ASA 9.0.3 Build 2451 and using the interactive SQL window, cannot export table to Dbase III - it starts to work and then produces "reserve...

Marc W

04-16-2009 08:54 AM
Nick Elson [Sybase iAnywhere]

There has been a report of something like this when the length of the parameters exceeds some internal display limitation. The first the to note is...

Nick Elson [Sybase iAnywhere]

04-15-2009 08:58 AM
Nick Elson [Sybase iAnywhere]

After a hard disc crash and parallel tape jam, one of our customers had to setup his databases again. Some tables are synchronized using...

Markus KARG

04-15-2009 06:47 AM
Markus KARG

Hi there I know if I want to copy a table and data on the same DB I can use:- SELECT * INTO New_Table FROM Old_Table And in Micro(spit)Soft SQL...

gchq

04-15-2009 01:03 AM
Breck Carter [TeamSybase]

OK, that is what I suspected. Using Task Manager to monitor memory consumption is problematic - see my blog post on the...

paul.baudouin@aktivconsulting.be

04-14-2009 11:06 AM
Glenn Paulley [Sybase iAnywhere]

Hello all...Can someone give me some info on where I can get some information on migrating Sybase ASA 9.02 to ASA 11.X? Any info would be greatly...

Mark

04-14-2009 10:51 AM
Mark

Dear all We have running above mentioned version of sql anywhere with the size of 6 GB. Now we have facing slow performance problem and day by day...

Adnan Jamil

04-14-2009 06:40 AM
Breck Carter [TeamSybase]

Dear All, I am still maintaining legacy ASA 7 database..my Boss asks me to develop web application (ASP.NET) using that database.. is it possible?...

Winanjaya

04-13-2009 01:55 PM
Jim Graham

Greetings, what's the way in ASA 9.0.2.3632 to find out which user has EXACTLY which rows locked? I'm familiar with sa_conn_info and...

Pavel Karady

04-13-2009 11:14 AM
Nick Elson [Sybase iAnywhere]

Apologies if this is not the right place for this question, but I'm sure people here have probably come across sites where the network clients...

steve m

04-12-2009 01:38 PM
Breck Carter [TeamSybase]

I'm trying to write a batch file to update several db's on the same server. Apparently the 'Use' statement doesn't work like I think it should. Is...

Jack Walton

04-11-2009 07:14 AM
Jack Walton

hello, in ASA 8, we lack the ability to control the order of elements in the list() aggregate function. it is OK. my question is, what can we say...

krisztian pinter

04-10-2009 02:13 PM
Glenn Paulley [Sybase iAnywhere]

I found that : 1) OUTPUT statement sometimes crashes the DB-server with "Assertion failed: 201501 (11.0.1.2052)" 2) Using OLE DB SAOLEDB for...

Andrei Iliev

04-10-2009 10:47 AM
Breck Carter [TeamSybase]

ASA Version 11.0.1.2044 on Window 2003 Enterprise edition. We only have two servers (Srv1 and Srv2) to set up our database mirror system. We...

Rachan Terrell

04-10-2009 10:33 AM
Breck Carter [TeamSybase]

We have tables that were assigned by two different "Grantor". Is there a way to remove one of the "Grantor"? SELECT user_name(P.grantee)...

Rachan Terrell

04-10-2009 08:43 AM
anil k goel [Sybase]

We're having some trouble with our database connections dropping. After looking at some other posts here I saw that ODBC logging might help, but the...

Jen

04-09-2009 12:24 PM
Jen

I would like to change the SAConnection for a .NET dataset before I populate the datatable. With MSSql ADO.Net driver the Connection property is ...

Jack Walton

04-09-2009 10:12 AM
Jack Walton

hi all how can i truncate the file asat0000.tmp , this file full my hard disk and make a stop the service, or any solution for this problem. thanks...

ivh

04-09-2009 07:16 AM
R. Pods

In article <op.urtb6ik3cm1ui8 (AT) karwst_pk (DOT) karatnet.hu>, pinter.krisztian (AT) chello (DOT) hu says... Because that's the way NULLs work in...

Markus KARG

04-09-2009 01:27 AM
Markus KARG

Greetings gurus, Can anybody give me an insight of a very delicate error message saying 'User XXX has the row in table YYY locked', which pops up...

Pavel Karady

04-08-2009 10:48 AM
Pavel Karady

Hello, as I've now overcome the problems I had earlier (dbtools 9 vs. 10 and rebuild due to assertion). The process is automated and it can...

Jan-Erik

04-08-2009 02:32 AM
Jan-Erik

First of all, apologize my orrible english and the fact that I'm totally new to Sybase. I'm the new outsource IT Manager for a company that have an...

Goldrake

04-07-2009 09:51 AM
Goldrake

I'm having either an error or I do not know how to fix it. the base problem is I have many queries using ~ (Tilde 126) in the where clause so when...

TWA2

04-07-2009 09:34 AM
TWA2

version: 11.0.0.1526 In my machine: I 've installed ASE15.0.3 and ASA11.0 (11.0.0.1526) When I startup dbisql.exe, it always crashed. Seems it has...

Sean.Ho

04-07-2009 09:23 AM
Nick Elson [Sybase iAnywhere]

Hi, I need to encrypt a database to protect sensitive information. I have created the database with the -ek encryption option. I am planning on...

chris90945@yahoo.com

04-07-2009 08:14 AM
Graeme Perrow [Sybase iAnywhere]

Hi We have a situation (v10.0.1) where we have a weekly full backup and numerous log backups during the week. The backups go to a DR site,...

Justin Willey

04-07-2009 06:37 AM
Breck Carter [TeamSybase]

I am trying to find the SQL Anywhere 9 runtime engine (rteng9.exe). Where can I get a copy of it?

Mike

04-06-2009 02:42 PM
Mike

Hello, May be the limit is still something like 900, but can you confirm me if it right or wrong. Is there also a limit in total digit length for...

riche.ddb@orange.fr

04-06-2009 12:26 PM
Reg Domaratzki [Sybase iAnywhere]

Hi. I am using the DBCreatedVersion function to determine whether a local database is a Sybase 8 or Sybase 11 database. I have encountered a...

mmanlove@nc.rr.com

04-06-2009 12:18 PM
Reg Domaratzki [Sybase iAnywhere]

Hello! I would like to create an event with a time limitation. The problem is that the main action in the event only once a day and only within a...

04-06-2009 11:47 AM

Hi There, I am getting this error and it crashes the Sybase DB Service: Internal database error *** ERROR *** Assertion failed: 106200...

Val Reyes, vreyes@hotelexpert.com

04-06-2009 09:29 AM
Josh Savill [Sybase]

I have an SQL Anywhere version 10 db running under Windows Server 2003. My need is to move the database to Mac OS X version 10.5.6. I have SQL...

rahinder@googlemail.com

04-06-2009 09:24 AM
Josh Savill [Sybase]

I created a merge module using Deploy SQL Anywhere for Windows, however when I try to add the merge module into a VS.NET 2008 setup project I am...

Ralph

04-06-2009 09:15 AM
Ralph

Can somebody take me back to databases 101 and explain this to me. We are in the process of moving our database from ASA6 up to SQL Anywhere 11. ...

Jeff Gibson

04-06-2009 06:59 AM
krisztian pinter

Have you compared row counts and page usages yet? "Nick Elson " <@nick@.@elson@@sybase@.@com@> wrote in message news:49d53120$1 (AT) forums-1-dub...

Chris Frick

04-03-2009 02:37 PM
Chris Frick

Hi guys, I have an interesting situation regarding Proxy tables and a query. The query is something like the following: SELECT * from p_Table1 WHERE...

falsedawn@hotmail.com

04-03-2009 01:38 PM
Karim Khamis [Sybase iAnywhere]

I created a merge module using Deploy SQL Anywhere for Windows, however when I try to add the merge module into a VS.NET 2008 setup project I am...

Ralph

04-03-2009 12:43 PM
Ralph

.... and ... needless to say, updating or even just reusing primary key values is usually a very bad thing ... "Nick Elson "...

Tejo

04-03-2009 11:32 AM
Nick Elson [Sybase iAnywhere]

Greetings all, I have a database on my laptop that I have not used for a while. My laptop crashed and I rebuilt it. I tried to run the database...

Paul Murray

04-03-2009 11:25 AM
Josh Savill [Sybase]

I've created a couple of classes in C++ that I want to use for database maintenance of ASA9, ASA10 (and probably ASA11) db's without rewrite or...

Jan-Erik

04-03-2009 08:52 AM
Jan-Erik