Try this: CREATE TABLE Test ( DummyCol INTEGER, CharCol VARCHAR(50), TimeCol TIMESTAMP );

Marc

07-02-2007 10:16 AM
Mark Culp

It is difficult, if not impossible, to determine the cause of your 10.0.1 issue (100% CPU) based on the information you have provided. As a start, I...

Glenn Paulley

07-02-2007 08:03 AM
Antonio Arena

Can anyone enlighten me as to why this table exists in some ASA9 databases but not in others? I am trying to write a script that will...

Ed Sinclair

07-02-2007 03:04 AM
Frank Ploessel

Hello: I have a Powerbuilder database (extension file .db) and I want to open with SqlAnywhere ODBC, but I can't. (I don't know) Can you tell me how...

Anne

07-01-2007 11:07 AM
Paul Horan[TeamSybase]

how to make ASA native .net provider available in datasource dialog box It is available only under OLE DB datasources. SQL Anywhere 10 latest...

vsv

06-29-2007 05:34 PM
vsv

How do you disable connection pooling in ado.net? I am using the oledbconnection object and passing a connection string...

Damien Murty

06-29-2007 01:24 PM
Damien Murty

In our office we use both ASA na SQL server. We are discussing the differences of the collation. If you want to store unicode characters in ASA you...

ontsnapt

06-29-2007 11:24 AM
Joshua Savill

I am new in this group. And this is the first time I use Sybase. Please kindly guide me. My company has a certified copy of SupportMagic Enterprise...

rejuso@gmail.com

06-29-2007 08:42 AM
Reg Domaratzki \(iAnywhere Solutions\)

Good day, Using ASA version 9, how do i create a text file to a client machine from a stored procedure? I have tried using the UNLOAD SELECT...

Irene Yu

06-29-2007 03:21 AM
Breck Carter [Team iAnywhere]

I run some queries against an ASE server using proxy tables. In 9.0.2 they take anywhere from 5-20 minutes depending on server load. Ever since I...

Chris Baker

06-28-2007 08:40 AM
Rob Waywell

Hi guys. Does aneone have an idea how to change the default password for the db file from "sql" to "1111" for example? Is there any utility or if...

Wndr

06-28-2007 08:13 AM
Wndr

Hello, ASA 9.0.2.3182 and jConnect, we suddenly get an error message –817 "too many temporary tables in connection". This application used to work...

Frank Ploessel

06-27-2007 12:07 PM
Frank Ploessel

ASA 9.0.2.3249 Hi, we tried sending emails with the smtp email functions. This works fine if we use an external smtp server with no...

Fabian Knauf

06-27-2007 11:50 AM
Frank Ploessel

is developer version limited form creating/viewing procedures? when ever I tried to view the procedure and function Sybase sql 9 crashes and cause...

gg

06-27-2007 10:11 AM
Shuchit

Hello all, I am evaluating SQL Anywhere 10 on Mac OS and I was wondering if there is a C/C++ api to connect a cocoa aplication to ASA. I am...

pprevot

06-27-2007 09:27 AM
pprevot

Our customer use ASA 8 databases with code page cp1252 at the moment. In the near future we like to upgrade these customer to ASA 10. Because we do...

Hans Groeneveld

06-27-2007 07:51 AM
Hans Groeneveld

We have two customers (from a large number of UK wide users) that are having problems running our database solution over a LAN. The two companies...

Dustin Bird

06-27-2007 07:06 AM
Chris Keating (Sybase iAnywhere)

have anyone found this error in their event log while running ASA9 Replication? Source: POP3SVC Category: Content Engine Description: Error 0x7d6...

cobolman

06-27-2007 04:22 AM
cobolman

I'm trying to use the merge module the "Deploy SQL Anywhere for Windows" created in version 10.0.1 with InstallShield 12 Express. When my install...

Jeffery Partridge

06-26-2007 11:49 AM
Jeffery Partridge

Hi, I'm having a problem using dbunload since it's generating the reload.sql file in UNIX format!!! (SA 10.0.1.3488 on Windows)... What't the...

Luis Porras

06-26-2007 09:36 AM
Luis Porras

Is the SQL iAnywhere JDBC driver available as a MSM merge module for installing on windows pc ? Basically looking to install the driver as part of...

Robert

06-25-2007 04:21 PM
Jeff Albion (iAnywhere Solutions)

I think I may have discovered a bug in ASA 10.0.1, or at least in Sybase Central 5.0.3281 upgrade wizard. Create a database in 9.0.2, create a table...

Jeffery Partridge

06-25-2007 03:14 PM
Jeffery Partridge

José Henrique (Zote) wrote: On the bottom of the connection dialog, there is a button marked "Tools". Click it, then select "Test connection". If it...

Graeme Perrow

06-25-2007 02:10 PM
Graeme Perrow

I am looking SQL anywhere version 6 ODBC Driver.. Where can i download the driver? TIA

srini

06-25-2007 06:52 AM
Chris Keating (Sybase iAnywhere)

http://1bosweb3.experient-inc.com/events/SYBASE/TECHWAVE2007/Agenda/default.html -- Breck Carter RisingRoad SQL Anywhere and MobiLink Professional...

Breck Carter [Team iAnywhere]

06-25-2007 03:13 AM
Breck Carter [Team iAnywhere]

How do i recover when there is no valid backup? Database is still there but log-file is missing and cannot be restored.

Mark Spoonman

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

trying to download ASA 10 developer version... But the link that I recieved by email gives me version 9.02 not 10..... Anyone got the correct...

Matt

06-23-2007 03:15 PM
Chris Keating (Sybase iAnywhere)

Hello Community, a customer gets error Message when trying to open database: Internal database error Assertion failed: 201129 File is shorter than...

Mark Spoonman

06-23-2007 09:47 AM
Mark Spoonman

Were we running on a 9 engine and since moving to 10.0.1.3415, the following statement no longer is true: IF EXISTS(SELECT * FROM...

JasonL

06-22-2007 03:34 PM
Bruce Hay

I am working on a high accuracy engineering application. I am Data Pipelining from Excel file (workbook). All data used in Excel in “Scientific” data...

niladri chatterjee

06-22-2007 01:50 PM
Stephen Rice

Hi, I have a question regarding DST. Normally in March in the night at a special day, when Changing from Winter to Summer-time, we have two times...

Peter xxxx

06-21-2007 02:20 PM
Carol Stone

Is it possible to change the name of the transaction log for an existing database in ASA 10.0.1.3488? Here is the situation. We have created an...

Jeffery Partridge

06-21-2007 01:56 PM
Jeffery Partridge

When i try to execute a sql script containing a call to a stored procedure, i am getting a -836 error (Procedure '%1' is no longer valid). However,...

Christian Hamers

06-21-2007 10:06 AM
Christian Hamers

SQLAnywhere 10.0.1.3488 Does SQLCONNECT environment variable always override even command line options!? I was running ulinit, but I was using the...

Spencer Wasden

06-21-2007 09:14 AM
Bruce Hay

Using ASA9.0.2, JDK (java app), iANywhere JDBC-ODBC driver on WINDOWS platform (XP) Interactive SQL and Sybase Central both have the FIND network...

Robert

06-20-2007 12:07 PM
Chris Keating (Sybase iAnywhere)

I tried to upgrade an authenticated database that was created under 9.0.2 on a system that had the OEM version SQL Anywhere Release 10.0.1.3488 on...

Jeffery Partridge

06-20-2007 11:05 AM
Jeffery Partridge

The installation starts to launch and goes in to a "not responding state" but continues to use a significant percentage of the CPU (actually the...

Anders Peterson

06-19-2007 04:29 PM
Ray Ruvinskiy

I use a software that interact with a db in ASA ver 6.00.03.3114, i need to capture all queries that software generates. Is there a way to do...

SASO

06-19-2007 02:59 PM
Graeme Perrow

Hi, I'm trouble, one of my users delete several records from database, this records are invoice and invoice itens ( 2 separated tables). How I can...

Amilton Maciel

06-19-2007 08:49 AM
Breck Carter [Team iAnywhere]

Is there any way to use the .NET compact framework 2.0 with SQL Anywhere 9? 9 is referencing 1.1 compact framework when we try to link against 2.0. ...

David DeRam

06-19-2007 07:47 AM
David DeRam

Calling all innovators! Nominate your project for the 2007 Sybase Innovator Awards. These awards recognize the best and brightest in Sybase...

Christine Bottagaro

06-19-2007 03:23 AM
Christine Bottagaro

When I unload data from a ASA table which has a column with a float data type, and if the value in the column for a record is large enough (example: ...

jsc

06-19-2007 02:01 AM
Frank Ploessel

Hi all I'm using ASA 902 build 3221. I have a table with a col of type integer and defualt value autoincrement! I inserted a number of records in...

Stelios Stylianou

06-19-2007 12:45 AM
Stelios Stylianou

Hi, IN ASA 9.0.2 build 3500, it seems the use of dblic as been changed. How can i specify the no. of licensed now? Thanks,

Devang Trivedi

06-18-2007 08:27 PM
Chris Keating (Sybase iAnywhere)

All, We are using a 9.0.2.xxxx OEM version of SQL Anywhere. We are trying to add a 3rd party EDI package, however we are getting access denied...

Michael Gould

06-18-2007 03:11 PM
Michael Gould

Running ASA 9.0.2.34xx on Windows I have a situation where I need to be able to turn an UNLOAD SELECT to a file on and off under program control,...

06-18-2007 01:47 PM

Hi All This question has probably been asked many times but is there a simple way to convert a Julian Date into a standard format? Thanks Roger

Roger Peffers

06-18-2007 10:26 AM
Frank Ploessel

I'm researching a case where PowerDesigner DataArchitect was "missing" some stored procedures during the reverse-engineering of a SA9.0.2.3480...

Paul Horan[TeamSybase]

06-16-2007 09:10 AM
Paul Horan[TeamSybase]

Hi all, does SQL Anywhere provides facilyt to send email like the way SQL Server does? -Mans

Mas

06-15-2007 02:58 PM
Chris Keating (Sybase iAnywhere)

I was using Crystal Reports XI with SQL Anywhere 9 and have recently upgraded to version 10. The problem now is everytime I refresh a report for the...

Geoff Chambers

06-15-2007 01:46 PM
Geoff Chambers