Hello, I have an encrypted Version 9.02 log file (and corresponding DB file). Is there a way that I can read (in text / sql command format)...

Robert Paresi

01-06-2010 05:19 PM
Glenn Paulley [Sybase iAnywhere]

Val, You're going to need to be more specific about this setup. 1) What version and build of SQL Anywhere (dbsrvX -v) are you running? 2) What is...

Josh Savill [Sybase]

01-06-2010 10:50 AM
Josh Savill [Sybase]

IMHO you should first contact your Sybase sales representative to check if your licence covers the runtime deployment to your customers....

R. Pods

01-06-2010 01:15 AM
Milind Joshi

ivh

01-05-2010 11:09 PM
Chris Keating (Sybase iAnywhere)

Quick help please! When I try to connect to ADO.NET Sample for Windows Mobile 5.0 pocket pc (in VS2008), everything with running SQL Anywhere server,...

QuestionMaker

01-05-2010 12:49 PM
Chris Keating (Sybase iAnywhere)

Hi, I have a peculiar problem. I have a small Java application which uses jConnect 6.0.5 to retrieve some data from an ASA8 database, process it and...

poetix

01-04-2010 12:27 PM
poetix

Is it possible to use db_string_connect() to connect to a DSN source created by SQLite driver? db_string_connect() API is returning sqlcode -103 ....

san

12-28-2009 06:57 AM
san

Hi, We need to bulk insert a lot of records into a table. The table contains a lot of LONG BINARY fields. Usually I can use the LOAD statement, but...

Irving Zhu

12-24-2009 11:38 PM
Irving Zhu

Hi, Is there any way to create a query that joins two tables that reside in two different databases? I use one database to collect raw data and...

Irving Zhu

12-24-2009 02:55 PM
Jeff Albion [Sybase iAnywhere]

Given the error message, my first guess is that the column is >25 bytes long. You appear to be using the Customers table from the SQL Anywhere 11...

Rob Waywell

12-24-2009 11:52 AM
Nick Elson [Sybase iAnywhere]

Hi all... Getting back into SQL Anywhere after being away awhile, so please forgive the newbie-ish question. I'm wanting to add a unique contraint to...

SQL Antwhere

12-22-2009 04:30 PM
Bob

Hi, How can I execute large SQL files (100 MB size). ISQL is not even able to handle files of 10 MB! I cannot delete the SQL History anymore,...

at

12-22-2009 01:27 PM
Nick Elson [Sybase iAnywhere]

Hi, One server , 2 client pc's. I can only connect from the 2 client pc's when the windows firewall is turned off. How can i still have the...

JVL

12-18-2009 02:59 PM
Chris Keating (Sybase iAnywhere)

Besides...what do you mean "reinstall the 32-bit components". This is a 64-bit OP system, and I downloaded the 64-bit Installation from Sybase and...

ALF

12-18-2009 12:45 PM
Chris Keating (Sybase iAnywhere)

Hello, I need some help. If I run this (in ISQL) or ODBC driver or...

Robert Paresi

12-18-2009 11:09 AM
Chris Keating (Sybase iAnywhere)

Is it necessary to deploy the charsets folder. If so, is it documented in the manual? Thanks Eric

ontsnapt

12-17-2009 05:22 PM
peter

We have a SQLAnywhere10 database running on a Windows 2003 server which has 4 processors and 4GB RAM. There is a complex stored procedure on the...

Aston Cockayne

12-17-2009 11:48 AM
Aston Cockayne

Using Adaptive Server Anywhere 9.0.2.3668. I have a system that has multiple connections to the database that all update records in the...

Paul

12-17-2009 08:17 AM
Glenn Paulley [Sybase iAnywhere]

So there is this SELECT: SELECT * FROM table1 WHERE txtvalue REGEXP '+' AND CAST(txtvalue AS DOUBLE) > 50; basically first it checks if txtvalue is...

nemo

12-17-2009 07:24 AM
nemo

Can somebody tell me how much free disk space is required on the OS (c drive) partition to run the 11.0.1 Build 2352 ebf? I am running into this on...

Jeff Gibson

12-17-2009 04:50 AM
R. Pods

Hi all, I can see from http://www.sybase.com/detail?id=1002288 that Sybase does not support Windows7 with SA 9.0.2 at this stage. My questions...

David MacDonald

12-16-2009 06:39 PM
David MacDonald

I'm having a problem on our Lan where a specific computer cannot connet to the sql anywhere 7 server unless the server computer is rebooted. Once it...

steve wa

12-16-2009 02:00 PM
Justin Willey

Our customer has workstations with windows XP and windows domain users. We have to install ASA7 with administrator account. But, other user on same...

Bofcilo

12-16-2009 01:42 PM
Nick Elson [Sybase iAnywhere]

Sudarat, Microsoft has disabled the "Interact With Desktop" feature for services on all of these OSes. This is a Microsoft security limitation. The...

SJ

12-16-2009 11:06 AM
R. Pods

I have an asp.net app that is reporting the following error when loading: Parser Error Message: Could not load file or...

Jack Walton

12-15-2009 04:48 PM
Kory Hodgson (Sybase iAnywhere)

At long last we have decided to upgrade our product database and distributed runtimes to SA11. We have been using the authenticated version of ASA 9...

Seth

12-15-2009 03:13 PM
Seth

A recent experience where a small but persistent and growing disk failure rendered useless over eight weeks of backups has forced me to re-think...

Doug Stone

12-14-2009 10:12 PM
Doug Stone

1) backup database directory 'c:\Monday\' wait before start wait after end transaction log truncate 2) backup database directory 'c:\logs\18\' wait...

Tom Mangano

12-14-2009 07:50 AM
Volker Barth

Hi, I don't know if this is exactly the best group to post this in but it seemed like it. I'm trying to get some validation from some Sybase techs...

Hylon

12-11-2009 08:24 PM
Hylon

Hello, I have installed the sqlany11.msi on Windows 7 and when I go to add a ODBC System DSN SQL Anywhere 11 is not listed as as option. Does...

LHudson

12-11-2009 12:57 PM
Jeff Albion [Sybase iAnywhere]

All, I am testing JasperSoft Business Intelligence Suite, I downloaded the trial version and I am able to run the demo application, my next step in...

Jorge Quintana

12-11-2009 09:17 AM
Jorge Quintana

How to identify what is growing the temp file of a database?

Martin

12-10-2009 05:24 PM
Lucjan Chmura [Sybase iAnywhere]

Can anyone please provide a link for a donwload of an ODBC driver for ASA8? I want to avoid installing the entire product on a specific computer, one...

brillisoft

12-10-2009 10:43 AM
David Kerber

I was creating a new user with only SELECT permission on some tables owned by DBA. If I connect this database using this new user it is possible to...

Heiko Helbig

12-10-2009 10:11 AM
Nick Elson [Sybase iAnywhere]

ODBC driver for SA 10 has check box <<Compress network packets >> Help for this option : Compress network packets Select this option to turn...

Bofcilo

12-09-2009 01:46 PM
Nick Elson [Sybase iAnywhere]

What is the difference between the fire_triggers option at the database level (right-click on the db name then select options then scroll down to...

Jon Owens

12-08-2009 03:53 PM
Jon Owens

SA server version 9.0.2.3456 32-bit, client has 9.0.2.3886 32-bit on win7 x64. I'm using the 32-bit jvm and 32-bit Eclipse for development, so the...

David Kerber

12-08-2009 02:24 PM
David Kerber

hi, i am pretty new in sybase, so excuse if this is a dumb question i dont know why this code does not execute: drop procedure if exists...

José Miguel Loor

12-08-2009 09:09 AM
Reg Domaratzki [Sybase iAnywhere]

PROCEDURE : create procedure READER_KS_MAGSTA (IN l_vd char(2), IN l_bd char(10)) begin declare l_kssifra char(13); declare l_id integer; set l_id...

Bofcilo

12-07-2009 04:00 PM
Bofcilo

Greetings, I have a generic query w.r.t to Sybase. Can any one please tell me with example, what is the difference between Sybase Open Server...

test

12-07-2009 03:26 PM
Nick Elson [Sybase iAnywhere]

I am using Visual C++ 6 to compile a .DLL that uses embeded SQL with an ASA 10 database. When I compile in release mode, I don't get any errors. ...

crconti

12-07-2009 02:33 PM
crconti

I run an ASA Server v9 on a Windows Server 2003 system (hosted server). I want to connect through the Internet from the clients to the server. The...

robz

12-07-2009 11:36 AM
peter

I have encoutered a problem when upgrading from sybase 5 to 10 on DBs. It happpens when it is run under regional settings other than...

peter

12-07-2009 11:27 AM
peter

I have two problems ... 1. Why is my db-server (dbserv11) under Linux (RedHat Linux) lasting around 20% CPU usage ... although nothing should happen...

12-07-2009 10:07 AM
Nathan Auch [Sybase]

Sorry for messing up the topic & Created in my first post... ErikE

ErikE

12-07-2009 08:21 AM
ErikE

You are mixing T-SQL with Watcom. IF .. THEN .. - is T-SQL syntax use IF .. THEN ... END IF; - as per Mark's suggestion. Additionally, looks like...

Lucjan Chmura [Sybase iAnywhere]

12-05-2009 12:04 PM
gg

WITH RECURSIVE Connections (ConnectionId, UserId, IPAddress, CommunicationLink, Application, LoginTimestamp, ConnectionMinutes, LastTimestamp,...

Jim Diaz

12-05-2009 10:59 AM
Jim Diaz

Hi All, We have just beocme an OEM and will soon be upgrading our clients form SQL 8 to 11. This requires an "authenticated" database. We will modify...

Mike Marston

12-04-2009 04:24 PM
Mike Marston

Has anybody configured ASA 10 ODBC on a Windows server 2008? we have an application that we use ASA 10 our installation program creates the...

Jorge Quintana

12-04-2009 03:11 PM
Jorge Quintana

I just installed SA9_Full_WIN_X64.902_EBF_3886.exe on top of my 9.0.2 x64 developer install, and it kills sybase central's startup. When I try to...

David Kerber

12-04-2009 01:53 PM
David Kerber