Is there any way to save the transaction log history through an unload? I am upgrading our database to Sybase 11 but after unloading using the "-an"...

Jonesy

10-02-2009 11:28 AM
Jonesy

Doug Stone wrote: Looks like a virus. I'd scan my PC immediately. Dmitri.

Dmitri

10-01-2009 06:16 PM
John Smirnios [Sybase]

I've installed SQL Anywhere in a custom directory and added iAnywhere.Data.SQLAnywhere.dll there. The .NET program seems to start up and continue to...

ints

10-01-2009 05:02 PM
Jen

How do I know the current cache size of Adaptive server Anywhere 7 database. Can I use it to optimize performance and how can I increase it.

deepali.sahni@ebookers.com

10-01-2009 12:23 PM
Deepali

I have what should be a simple select statement which I can't get my head around. I have a situation where we sell a product line and these details...

Roger Peffers

10-01-2009 12:12 PM
Glenn Paulley [Sybase iAnywhere]

Hi all...quick question: we're thinking of applying build 2299 to our current version of SQLAnywhere 11.0.1.2044. If the setup program for 2299 goes...

Mark

10-01-2009 08:16 AM
Breck Carter [TeamSybase]

I have been assigned a project for performance optimization of a Swiss ASA 7 database that is being used by Dolphin application. How do I optimize...

deepali.sahni@ebookers.com

10-01-2009 04:38 AM
Deepali

Hi, I am running Adaptive Server Anywhere 9 (9.0.2.3593). What I need is to setup off-site backup that will be updated on hourly basis with the...

Drabina

09-30-2009 08:44 PM
David Fishburn [Sybase iAnywhere]

Could someone help me understand the difference between sort_collation = Internal and sort_collation IS NULL? The documented allowed values for the...

Dan Konigsbach

09-30-2009 06:19 PM
Nick Elson [Sybase iAnywhere]

When a database is run using AES encryption, are the database log files encrypted also?

Steve Garland [ASTA]

09-30-2009 03:35 AM
Volker Barth

Hello all...we have migrating our Sybase ASA databases from Adaptive Server Anywhere 9.0.2.2451 to SQLAnywhere 11.0.1.2044. If we find there is a...

Mark

09-29-2009 11:38 AM
Nick Elson [Sybase iAnywhere]

To trouble-shoot my computer's 10 minute+ startup, I downloaded Mike Lin's Startup Control Panel... http://www.mlin.net/StartupCPL.shtml Under the...

Doug Stone

09-29-2009 10:41 AM
Dmitri

Hi, for SA11 on Win XP 32-bit, the link in the start menu for the ODBC Administrator is not done properly. The link points to...

09-29-2009 10:32 AM

Hi all, We have a client that is using ISA server and has all their http traffic proxied and possibly other traffic but I'm not sure. The problem...

visiperl@gmail.com

09-28-2009 08:13 PM
Nick Elson [Sybase iAnywhere]

Hello eveybody, This is the first time in Sybase world. I'm very new in SQL Anywhere. I'm just download SQL Anywhere 11.0.1 and already installed...

Suntisuk

09-28-2009 08:05 PM
Nick Elson [Sybase iAnywhere]

ASA Version 10.0.1.3903 We use dbbackup to execute backup. This is in a script in which we do a stop of the db ( net stop ...), the backup, and then...

Claude

09-28-2009 07:07 PM
Nick Elson [Sybase iAnywhere]

Hi. I call raiserror with a custom message. Does anyone knows how to capture it ? For example - ---- raiserror 21000 .... ---- exception when...

poptcat

09-28-2009 07:04 PM
Nick Elson [Sybase iAnywhere]

For SQLAnywhere 10: I am looking for the above file, in order to make a database connection using this JAR file. Can someone tell me wher this file...

murray_sobol@dbcsmartsoftware.com

09-28-2009 04:51 PM
Kory Hodgson (Sybase iAnywhere)

I have purchased SQLAnywhere 11.0.1 and a runtime license. Where do i find the files for the runtime engine? The download center states that the...

chris barown

09-28-2009 10:23 AM
Chris Keating (Sybase iAnywhere)

Hi all, In 9.0.2. the Index Consultant exists on Sybase Central and Interactive SQL. However, in 11.0.1. I can only find it in the latter. You...

Shao Chan

09-28-2009 10:18 AM
Shao Chan

Hi, I have a weird issue here. In windows 2000, if I login as a console user and try to open a sql anywhere 11 DB file in Sybase Central, it...

Niroshan

09-28-2009 09:34 AM
Kory Hodgson (Sybase iAnywhere)

Hello, is it possible to get the filename including path from a running database on a SQL Anywhere 9.0.2? I need the path from the view of the...

AH

09-28-2009 03:57 AM
Volker Barth

We are trying to implement an audit trail of changed column values in a table. I would really like to use a cursor to dynamically loop thru...

Bill Aumen

09-25-2009 05:23 PM
Nick Elson [Sybase iAnywhere]

in the sysobjects one column is there with name crdate, but this is not updated properly. If anyone is having any info please help me. Balu...

Balu

09-25-2009 04:30 PM
Nick Elson [Sybase iAnywhere]

Hallo, The ASA 9.02 Setup (WinXP SP3) sets some environment variables (e.g. path), but this variables doesn't work until a logoff/logon. I think the...

Thomas

09-25-2009 01:51 PM
Thomas

I am looking to see if there is a way to trap for errors when using the command EXECUTE IMMEDIATE in an event. I use it to perform hourly backups of...

Ben Baker

09-24-2009 04:14 PM
Breck Carter [TeamSybase]

Hello all...we are using the transaction log to view all our changes to our database. I was just wondering if there was anyway to capture the SELECT...

Mark

09-24-2009 10:47 AM
Glenn Paulley [Sybase iAnywhere]

Hi, I can't figure this out. I have two tables. Roughly: CREATE TABLE iSales ( SalesDate DATE NOT NULL, StoreNum ...

Edgard L. Riba

09-24-2009 10:40 AM
Edgard L. Riba

hi, all, We are doing a SA11's performance test against mssql 2000/2005. The test application is coded in c# with ado.net. Please see the datail...

Ivan.deng

09-23-2009 10:55 PM
Ivan.deng

Hello, I'm running this version on Window Server 2003 SP 2. When I create my trigger in Power Designer 9.5.2.873 I use the following: create...

eric

09-23-2009 04:04 PM
eric

I notice our production .db file is 2.5 Gb It should only be two hundred Mb. I know this because I unloaded and recreated the db in a different...

Roshintosh

09-23-2009 03:48 PM
Breck Carter [TeamSybase]

I have been having issues upgrading customers ASA9 databases to SA11. In many cases the instructions on how to upgrade the the Version 9...

Glenn Barber

09-23-2009 02:44 PM
Glenn Barber

Hi, using ASA 9 I'm used to schedule an event using SC: "Properties" popup menu entry, "Conditions" tab, Radio Button "By the following schedules",...

Chris Werner

09-23-2009 10:22 AM
Chris Werner

Hello all...we have successfully migrated our Sybase ASA 9.0.2 DB to SQLAnywhere 11.0.2044 DB. Previously, to connect our front-end apps to the...

Mark

09-23-2009 09:51 AM
Mark

Hi All, I have installed SQL Anywhere 10.5.2.3873 on Windows 7 x64 and the installation was no problem. When I start a database with dbeng10 and try...

Thomas Bodell

09-23-2009 05:49 AM
Thomas Bodell

Sybase 9.0.2.3534 How do I truncate a transaction log for a database involved in Mobilink Replication? I need to know this for the consolidated...

Herman

09-22-2009 02:23 PM
Josh Savill [Sybase]

Hi!!!, I migrate to windows 2008, and install de sql anywhere 9 with all patch:SA9_Full_WIN32.902_EBF_3850 and SA_902_Win32_EN_patch. When i run...

vcardona.setitem,com

09-22-2009 12:47 PM
vcardona.setitem,com

I'm having a problem connecting to a sybase10 database. We have a 3rd party application built in C# connecting to a Sybase 10 database. The...

v0id

09-22-2009 09:22 AM
Reg Domaratzki [Sybase iAnywhere]

Hello, I have encountered a problem with "iAnywhere.Data.SqlAnywhere" Provider. Using: - Sybase Sql Anywhere Developer Edition (v 11.0.1.2250) -...

Etroid

09-22-2009 09:21 AM
Chris Keating (Sybase iAnywhere)

Hello, I am getting an error when trying to run dbbackup for a database that is in use. If I run the same dbbackup command when no one is accessing...

Dave B

09-22-2009 09:11 AM
Graeme Perrow [Sybase iAnywhere]

Hi there, Quick question. If I generated a certificate with OpenSSL would it be the same structure as using createcert? Would the certificates be...

Shao Chan

09-21-2009 05:01 PM
Shao Chan

Receiving these types of errors in the Event Log. Database Services need to be restarted for applications to work. Not sure where to start. Each...

Andy

09-21-2009 11:54 AM
Kory Hodgson (Sybase iAnywhere)

Is there a way to recover the license key from an installation. We are moving our installation to a larger server and can't find the...

Jack Walton

09-21-2009 11:50 AM
Shao Chan

Sybase 9.0.2.3534 I need to upgrade my consolidated db and local db's from SQL Anywhere 9.0.2.3534 and have a few questions: 1. Do I need to upgrade...

Herman Miller

09-21-2009 10:19 AM
Josh Savill [Sybase]

hi,all, We have a potenial customer who use mssql now. The speed of db is the most critical part for them. Use iSQL, I write a...

Ivan.deng

09-21-2009 04:03 AM
Ivan.deng

I have a .NET 2.0 Application configured for anyCPU. I connect to SQL Anywhere 9.0.2.3850 via System.Data.OleDb specifying an ODBC Datasource in the...

Markus Accola

09-21-2009 02:32 AM
Markus Accola

Perhaps some of you have an idea on this topic Once a Month i need a Database snapshot at a specific Date/time point. Means my monthly inventory...

tduemesnil

09-21-2009 02:30 AM
tduemesnil

I'm trying to upgrade a Windows 2000 server. All service packs and updates applied on the OS. Currently have the base version of SQL Anywhere...

Jeff Gibson

09-18-2009 04:27 PM
Breck Carter [TeamSybase]

Hi I have a problem with a Query , im usin free tables dbf m_prec The Structure is NAME TYPE LEN DECIMALS

Roberto Negrete Cervantes

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

Today they asked me to solve a problem that occured when creating a foreign key. This problem occured on some databases. The message I get is SQL...

Ontsnapt

09-18-2009 09:04 AM
ontsnapt