NEWB ALERT! Okay, so we run Sybase Anwhere 8 here along with InfoMaker 6. I have a database of doctors and want to run a query to check out if any...

SteveLord

05-19-2009 11:25 AM
Kory Hodgson [Sybase iAnywhere]

I posted today, but cannot see my post...

Paul Murray

05-19-2009 10:44 AM
Chris Keating

I haven't seen a new message in any of the sybase NG's since 15 May, except the on I posted in .test. I tried resetting the message counters in my...

05-19-2009 10:41 AM
Chris Keating

On "Table Properties window: Miscellaneous tab" their is an option for "Free space" Free space specifies the amount of free space you want to reserve...

Rachan Terrell

05-18-2009 03:56 PM
Rachan Terrell

Dear All, I am still maintaining legacy database ASA 7 ;<( .., because of economic global crysis, now we don't have budget to purchase the newest...

Winanjaya

05-18-2009 12:37 AM
Winanjaya

Hi I have ASA 10.0.1.3831 running DB on an Windows 2003 SP2 server. The DB runs with no issues and DB clients can connect. I have another server...

Dustin Bird

05-17-2009 06:37 AM
Dustin Bird

Hello, I have a lot of monitoring programs and end-user programs for them to support the databases. Going from 9 to 11 has made it so we have to...

Robert Paresi

05-15-2009 05:56 PM
Robert Paresi

I have a 23GB database that seems to be corrupted. Assertion fail on startup. With ASA5 there was a trailing command line option to force the...

Jon Springs

05-15-2009 01:55 PM
Jon Springs

I receive the error above when attempting to revoke connect from a user. Is there some way to find out exactly which procedure(s) are being used...

Dave Foulkes

05-15-2009 12:36 PM
Dave Foulkes

We updated our customers from 8.0.3 to 11.0.0 some weeks ago, and meanwhile we detected two of them who had broken DB files (validation of table...

Markus KARG

05-15-2009 11:40 AM
Nick Elson [Sybase iAnywhere]

select list(a) from (select '' as a union all select '' as a) t returns '' tried on ASA 8 and 9

krisztian pinter

05-15-2009 10:50 AM
Nick Elson [Sybase iAnywhere]

Hi, I try to use MS EF with ASA 11.0.1.2052 and MS VS 2008 SP1 on a VISTA 64-bit OS. This was working fine on 32-bit XP. Since I run it on 64-bit...

at

05-15-2009 06:01 AM
at

I posted the message below about four years ago and got no response. The question has come up again, so I figured I would see if anyone has any...

Seth

05-14-2009 04:27 PM
Glenn Paulley [Sybase iAnywhere]

Have been trying to get SQL anywhere monitor installed and have installed the latest ebf but it causes java.exe to peg out the cpu. I have tried...

Bruce jackson

05-14-2009 03:56 PM
Dan Petker [Sybase iAnywhere]

Need your help...got this message when trying to applying transaction log: Unknow error (-29969) when we're running: "%SQLANY10%\win32\dbeng10"...

Rachan Terrell

05-14-2009 11:08 AM
Nick Elson [Sybase iAnywhere]

I did a search on this and was unable to come up with a reason for this. We are in the process of building the install script to include SQL...

Jeff Gibson

05-14-2009 10:56 AM
Chris Keating [Sybase iAnywhere]

We're rebuilding ASA version 10.0.1.3784 to 11.0.1.2052 and we have several autoincrement columns which we need to deal with. Our question is when do...

Rachan Terrell

05-14-2009 10:43 AM

I have built a BlackBerry application with the Application Development Framework that I am trying to deploy to my BlackBerry. I have successfully...

ehogan@globalbay.com

05-14-2009 09:57 AM
ehogan@globalbay.com

Hello, I know how to grant the select permission to a user for a certain table. But we have dozends of tables and every now and then new tables...

Marten Lehmann

05-14-2009 06:53 AM

Hi I have simultanious connection to the same Sybase database from Excel and Sybase Interactive SQL program. I send data to the database from Excel...

Jacques

05-14-2009 05:35 AM
Glenn Paulley [Sybase iAnywhere]

I have two SQL Anywhere (home grown) 5.0 applications that I need to move from an older server to a new server. What do I need to do to move those...

Joyce.Yates@pbsg.com

05-13-2009 04:44 PM
Paul Horan[Sybase]

Elias, I recommend opening a technical support case for this issue. The thread has been ongoing for a while and it appear debugging is necessary. I...

Josh Savill [Sybase]

05-13-2009 08:55 AM
Josh Savill [Sybase]

Elias, I recommend opening a case with technical support. This issue is going to require some debugging to determine why the database server will...

Josh Savill [Sybase]

05-13-2009 08:44 AM
Josh Savill [Sybase]

Hello, I'm running SQL from several joined Proxy Tables, which referes to another ASA 9 database server. And it returns not all rows. My SQL...

Evaldas

05-13-2009 06:11 AM
Glenn Paulley [Sybase iAnywhere]

Hello all, I have a quick question (and I hope there's a quick answer). Is it possible to retrieve a dos/windows environment setting with sql...

Desperado

05-13-2009 02:47 AM
Desperado

hi all, I'm writing a stored procedure for ASA9.0.2, here's some code: ------------------ .... declare @v_d datetime, @v_d1 datetime, @v_d2...

zs

05-12-2009 09:40 PM
zs

SQL Anywhere 11.0.0.1578 I have 2 separate SQL Anywhere 11 databases, both running on the same server. When a row is added to a particular table in...

Bill Aumen

05-12-2009 05:04 PM
Bill Aumen

I am running SQL Anywhere Studio 9.0 on a Windows 2003 Server. 37 licenses are available and only 24 are used. After a server reset, all my clients...

Mario Pineda

05-12-2009 03:00 PM
LHudson

We are upgrading from 10.0.1.3784 to 11.0.1.2052 and would like to substantiate that when using "Unload Database Wizard" Select a Database - Specify...

Rachan Terrell

05-12-2009 11:02 AM
Rachan Terrell

Are you aware of any code generation tools that work with Sql Anywhere version 11. I have tried CodeSmith but encountered a number of problem trying...

Ralph

05-12-2009 09:53 AM
Ralph

Currently in process of upgrading DB from ASA 10 to 11 Current DB pre-allocated size is 8GB After unloading Data Unload folder is ~ 6 GB in...

Charles.Gogolin@stanleyassociates.com

05-12-2009 09:52 AM
Rachan Terrell

Where can I report this as a defect so that it will be addressed? - Leo

Leo Tohill

05-11-2009 08:17 AM
Chris Keating [Sybase iAnywhere]

Hi I have done a vast research on the net with no avail. This seems to be a problem with no answer. The situation: I read values from excel charts...

Jacques

05-11-2009 02:46 AM
Jacques

SQL Anywhere 11. Our Windows server crashed this evening. When the systems guy brought it back up, the database server would not restart. The log...

Rebecca Snyder

05-10-2009 02:55 PM
Breck Carter [TeamSybase]

We are currently experiencing a growing temporary file problem. Watching one of our sites we can see a growth of 100 - 200 MB a day at one site we...

Kyle Danielson

05-09-2009 05:13 AM
Breck Carter [TeamSybase]

Sql Anywhere 9.0.2.3778

Bob Piskac

05-08-2009 12:46 PM
Bob Piskac

I am trying to apply a transaction log. It would appear that I am having this engineering problem. Is there anything I can do to fix...

Bob Piskac

05-08-2009 12:45 PM
Bob Piskac

We have a 32-bit application which is built with MSVC 2005 and running in Windows environment. Without recompile the application to 64-bit, can I use...

Mei

05-08-2009 12:29 PM
Jeff Albion [Sybase iAnywhere]

Hi all, I'm trying to access data in an MS SQL 2000 SP 4 server from an ASA 8.0.3.5574 database running on a different server. Basically, I just...

Volker Barth

05-08-2009 11:44 AM
Volker Barth

GW wrote: In my test, DB shrunk by 33%. Dmitri.

GW

05-08-2009 04:13 AM
Breck Carter [TeamSybase]

Dear All, I am developing a call center application using VB6 and ASA 10 as my DB. my application doing synchronus database queries...

Winan

05-07-2009 04:16 PM
Kory Hodgson [Sybase iAnywhere]

I have a client that had some personal changesin their IT department and they can't seem to find which machine the database server (version...

Jeff Weir

05-07-2009 10:37 AM
Jeff Weir

Hello all...We are migrating our Sybase ASA Database from ASA 9.02 to SQLANYWHERE 11.0.1. Everything seems to be going well except for a series of...

Mark

05-07-2009 10:01 AM
Mark

That would be your problem here. The second part of that message tells us that the client connection's charset is UTF8, not 1252. That could...

Ontsnapt

05-07-2009 09:53 AM
Nick Elson [Sybase iAnywhere]

I have a stored procedure (A), which I need to call from another stored procedure (B). The data pulled from (B) is then inserted into a temporary...

khoke

05-07-2009 07:39 AM
khoke

hello, we repeatedly run into a problem with table statistics. the usual symptom is that a full scan is issued on a table while an index scan would...

krisztian pinter

05-07-2009 06:17 AM
krisztian pinter

Hello, Our database has been around since a while (10 years more or less) and has grown with the years. Before, the policy was that you could...

Mim

05-07-2009 06:09 AM
Glenn Paulley [Sybase iAnywhere]

Hello, we are migrating our customers to the recent ASA EBF 9.0.2.3804 (because of stability issues). Some of our customers are running their...

LM

05-07-2009 01:05 AM
LM

Sybase 9.0.2.3534 I need some clarification on defining input variables within Stored Procedures. Does it make a differences if a Stored Procedure...

Herman Miller

05-06-2009 09:42 AM
Nick Elson [Sybase iAnywhere]

Hello, I'm trying to upgrade our VS 2003 project to VS 2005 using SQL Anywhere 11. In our VS 2003 project we are using the...

pino227@gmail.com

05-06-2009 05:04 AM
Shao Chan