Hi All, Some tool which converts ASA/ASE database to MySQL Database vice versa. We have one project requirement; we are looking for some tool...

Jenny

01-27-2010 06:36 AM
Martijn Tonies

Currently, all our application tables are owned by dba. Is this considered good practice? If no, is there an easy way to change ownership of all our...

Doug Stone

01-27-2010 05:16 AM
Breck Carter [TeamSybase]

One of our customers wants to have crystal reports access to our application's database. I think the best path is to setup a read-only user with...

Doug Stone

01-27-2010 03:58 AM
Volker Barth

I have an ASA9 database and get the above error why trying to start it... Does anyone have any ideas on how to recover or repair it. I have already...

Dave

01-26-2010 03:19 PM
Josh Savill [Sybase]

ASA 9/10 armt.40 odbc Hi, we discovered, that in C++ error handling within a sybase function does not work when an error occurs within a...

Fabian Knauf

01-26-2010 12:18 PM
Nick Elson [Sybase iAnywhere]

If I run this: call sa_split_list('AA','\x0d\x0a') I get this result set (which is what I expect) line_num,row_value 1,'AA' If I call this: call...

Clive Collie

01-26-2010 10:58 AM
Bruce Hay

Hello, I have a question about "clustered indexes. After I looked into the documentation, I understand it this way: when using "clustered indexes"...

Ingmar

01-25-2010 01:58 PM
Nick Elson [Sybase iAnywhere]

Our products are still running ASA 8.01 (upgrading to 10 soon). We're aware that ASA 8 .x is no longer supported, but does anyone know if it will...

Al Seltenreich

01-25-2010 12:55 PM
Nick Elson [Sybase iAnywhere]

Anyone have any experience? Tips? Advice? Cautions? Much appreciated, -- -----Jon-----

Jon Springs

01-25-2010 11:25 AM
Roger Holmes

Hi - I wonder if any can advise me on the following issue? I need to run two active databases (e.g. This1.db and This2.db) I want to do an SQL...

Alastair Walker

01-25-2010 07:50 AM
Alastair Walker

We are using Adaptive Server Anywhere 9 for a website coded in ASP.Net (2003). We use services for each database. Each service is set as a "Personal...

S. Male

01-25-2010 07:10 AM
Chris Keating (Sybase iAnywhere)

NewsGroup: sybase.public.powerbuilder.database Date: Jan 24,2010 10:46 pm Created by: Jenny Topic: Some tool which converts ASA/ASE database...

Jenny

01-25-2010 05:19 AM
Jenny

Hi, we are using SQL anywhere 10/11 how can we determine the DB Size for SQL anywhere? I found something similar for MSSQL & mySQL...

Harjo Kompagnie

01-25-2010 12:05 AM
Arthur Hefti

I've been asked to create a backup of a record (which has 75 fields) which can be restored if necessary. I'd hoped to be able to tell if the current...

P Merritt

01-21-2010 12:20 PM
P Merritt

Hi all. I have a ASA server using dbsvr8.exe. The problem: I have configured a service on Sybase Central tool in the Events module on the database....

Jgucani

01-21-2010 06:12 AM
Breck Carter [TeamSybase]

Scenario: Windows XP running Sybase network server as a service under version 10. Installation of version 11.0.1.2044 proceeds with...

Richard Hinder

01-20-2010 05:26 PM
Richard Hinder

The specific error that you are getting indicates that your PowerBuilder transaction object property "DBMS" is not set. You will need to determine...

Chris Keating (Sybase iAnywhere)

01-20-2010 03:14 PM
Chris Keating (Sybase iAnywhere)

Hi all, having no luck importing a structured XML file into a datawindow using PowerBuilder I wonder if and how that may be done in ASA (V >= ASA...

Chris Werner

01-20-2010 10:45 AM
Jason Hinsperger

Greetings, any possibilites in ASA 9 and SA 11 finding out the exact size of a row in e.g. bytes? Thanks in advance, Pavel

Pavel Karady

01-20-2010 02:10 AM
Breck Carter [TeamSybase]

I have read about this in the manual. I would like to know if a unique constraint creates a unique index. If columns are not allowed to be null,...

ontsnapt

01-19-2010 03:49 PM
Nick Elson [Sybase iAnywhere]

This sql causes an error. select dbo.xp_write_file('c:\\xmlfile.xml', (select xmlData from "DBA"."sp_getxmlData"(1, 770280))); Internal database...

Bob Piskac

01-19-2010 11:08 AM
Bob Piskac

Hi, We use PB v9.0.2 ebf 3044 32 bit version My new computer is 64 bit windows 7. I purchased the windows professional so that I could run xp mode...

Loya Kelso

01-19-2010 08:58 AM
Dmitri

When I create SQL queries with multiple tables in .NET the datasets that are generated do have only the column names. The table name is not included....

Hans Groeneveld

01-19-2010 05:26 AM
Hans Groeneveld

We are running the OEM version of ASA 9.0.2.2451. We have run into an issue running another vendor's software (Pervasive Data Integrator) where the...

Heather T.

01-18-2010 04:15 PM
Heather T.

This is a 'fifo' type of problem and should have nothing to do with disk space. I wonder if this has something to do with the long file name. Can...

Nick Elson [Sybase iAnywhere]

01-18-2010 03:06 PM
Nick Elson [Sybase iAnywhere]

Hi, I'm new in this forum. I installed Sybase Anywhere Studio 8 on a Win2000 Server -> all OK. When I install on a Win2003 Server, the same...

renzo

01-18-2010 05:37 AM
Breck Carter [TeamSybase]

I haven't redone an installation to confirm this, but it appears that ebf 3924 for 9.0.2 x64 puts out an old version of dbjodbc9.dll. I had...

David Kerber

01-15-2010 03:16 PM
David Kerber

Hi. I'm looking to move some legacy applications from an old server to a new one and we have, at some point, lost the server software install disk....

AThomson

01-15-2010 03:04 PM
Nick Elson [Sybase iAnywhere]

SA10.0.1.3784 Windows Server 2003 Windows XP Pro I've searched the online documentation and was unable to find anything. Is there a database server...

Scott Huerta

01-15-2010 02:42 PM
Scott Huerta

Hi, I've installed SQL Anywhere 11.0.1 Developer and subsequently applied the EBF patches we needed in our environment. Now we got a license key for...

Ivan Boscolo

01-15-2010 02:19 PM
Josh Savill [Sybase]

Hi all, Our original CDs to version 9.00 included installation disks for both 32bit and 64 bit OS. Until now, we only have 32bit...

Stelios Stylianou

01-15-2010 10:19 AM
Stelios Stylianou

Hi, I would like to configure a backup event in my SA Monitor database. Can anyone tell me what the DBA username / password is please? Also,...

Philip Harris

01-15-2010 04:57 AM
Philip Harris

I am trying to setup live backup on the SQL Anywhere 9.0.2.3593. Main database is located on a different server than the server that...

Drabina

01-14-2010 03:47 PM
Drabina

Hi We use Delphi using the sybase DLL's and upgraded from sybase 10 to 11. create table table1 (a int); create table table2 (a int, b int); insert...

Eric ten Westenend

01-14-2010 11:02 AM
Eric ten Westenend

Hi! We have problem with missing variables. Client (Windows application) is connecting to database network server by ODBC. After it is connected, we...

Krzysztof Korolonek

01-14-2010 09:11 AM
Glenn Paulley [Sybase iAnywhere]

Is there a way to run multiple instances of dbbackup from batch file? I have to execute live backup of 50 databases and would like to create batch...

Drabina

01-13-2010 07:29 PM
Nick Elson [Sybase iAnywhere]

I've searched the manual and this newsgroup, but as yet I've failed to find a property which identifies the server as being 32-bit or 64-bit. Is...

Dave Foulkes

01-13-2010 11:05 AM
Dave Foulkes

The dbtran utility crashes (terminates unexpectedly) when using the "- it" flag. Has anyone experienced this? Is this a known issue? On a side...

Jonesy

01-12-2010 02:43 PM
Jeff Albion [Sybase iAnywhere]

Is it safe (though possibly unwise) to rely upon a particular order of evaluation in a statement? The particular instance I was curious about...

Dave Foulkes

01-12-2010 01:51 PM
Dave Foulkes

We have a client running SQL Anywhere 11.0.1.2355 and hosting their database on a Windows XP SP3 32-bit workstation. When they try to connect to...

Jesse

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

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 10: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 09: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 09: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 01: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 09: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 07: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 08: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 07: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 06: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-08-2010 12:50 AM
Mike Paola