Hello All, I'm using asa 8.0.2 4308. I am attempting to create a table using a UNIQUEIDENTIFIER as the primary key to use in conjunction with...

mike sowerby

01-12-2004 11:03 AM
mike sowerby

Hi every one, When a huge update sql script is running, I'd like to be sure to be the only one user connected on the ASA8 db. First, I disconnect...

Matti

01-12-2004 10:21 AM
Matti

What is latest official ASA 8.x version? We are running with 8.02 (4251). Is 8.03 already available? If yes, can I download that...

Hans Groeneveld

01-12-2004 10:01 AM
Hans Groeneveld

Could you explain me more detail wath this means: Java objects in the database not supported Support has been removed for storing data as Java...

marco@sybaseperu.com

01-12-2004 08:54 AM
Jim Cullison

Ver.: Asa 8.0.2 Plug_in 4215 I cant see my services tab, but I can see utulity tab. The server OS= Windows 2003 server and I had a error message...

Thrax

01-12-2004 07:50 AM
Thrax

I applied the Netware patches and everything is fine. It's been a long wait, but it was worth it. "Bob" <bob (AT) nespam (DOT) com> wrote

Bob

01-12-2004 07:32 AM
Bob

Hi, How to connect to sql db through modem connection. ---== Posted via the PFCGuide Web Newsreader...

Bharathi

01-11-2004 01:07 PM
Greg Fenton

I'm having the same problem with version 8.0.2 EBF 4339. The symptoms are pretty much the same. We have about 40 or so users connected to the server...

Janos Veiszlemlein

01-11-2004 11:52 AM
Janos Veiszlemlein

I have a disk space question for ASA9. I have a small laptop that I still run Windows 95 on. It's a 150MHz machine with 80 meg of ram. (OK, you...

Jeff Gibson

01-10-2004 09:26 AM
Breck Carter [TeamSybase]

The doc's seem to indicate that I need not do anything for ASA to automatically take advantage of multiple CPU on the server. Is this true? Also,...

Kumar Manuel

01-10-2004 08:47 AM
Chris Keating \(iAnywhere Solutions\)

How to best verify that database is not corrupted? Is running VALIDATE TABLE for all tables the only solution?

azaleski@anzasoft.pl

01-10-2004 08:44 AM
Chris Keating \(iAnywhere Solutions\)

That is excatly the point. It's not about rights, it's about external logins, and CURRENT USER must have external login defined to use remote tables...

Peter Beno

01-10-2004 04:25 AM
Peter Beno

Hi all, When a generic constraint is violated, in the exception message is reported it's name ... for example: "CK_T2_Flag" in : "Constraint...

Nicola Cisternino

01-10-2004 03:30 AM
Nicola Cisternino

Hello: Before I ask, I'll tell you upfront that I am not a database person, I'm a doctor by profession. My questions are probably ignorant but I'm...

mtuccio1@stny.rr.com

01-09-2004 05:28 PM
Greg Fenton

I wish to write an application on the Pocket PC that connects directly to the ASA Database on our server. I don't want to use Ultralist because...

Mark Stoker

01-09-2004 01:30 PM
Jason Hinsperger

Recently someone posted the preferred steps to convert a version 5.5 database to version 9.0. One of the steps was to "increase the size of the new...

Bill Urbanovsky

01-09-2004 01:28 PM
Bill Urbanovsky

I am using the trial of Sybase 9 Studio and have the following error: Database server rejected connection: Database server connection limit...

Eugene V. Goldberg

01-09-2004 01:22 PM
Jason Hinsperger

Hello guys, I am trying to use ADO connection to Sybase 9, and want to post MEMO and BLOB fields to database. I am having exception "Counter field...

Eugene V. Goldberg

01-09-2004 01:13 PM
Jason Hinsperger

Bill Urbanovsky wrote: ALTER DBSPACE can be used to pre-allocate disk space for the dbspace. For example, if your dbspace is currently 10MB and you...

Greg Fenton

01-09-2004 11:43 AM
Greg Fenton

We are using Sybase Adaptive Server Anywhere Version 8.0.2.3601 and when we try to reverse engineer an existing database, the views are not coming...

SM

01-09-2004 11:35 AM
SM

found some articles on this from 2000 but no solutions... Event ID: 1008 Source: Perflib Event Type: Error Description: The Open Procedure for...

Gerg Chamblin, Jr.

01-09-2004 11:13 AM
Reg Domaratzki

version: ASA9 build 1250 I have a stored procedure that is called by a Delphi application ( which uses ODBC to access the database). The stored...

Dave Westphal

01-09-2004 10:46 AM
Dave Westphal

Using SQL to retrieve some data. A field in a remote Oracle table is formatted with hyphens like P304-01-01, and i need it to retrieve as P3040101. ...

davidson.ted@burlington.com

01-09-2004 10:42 AM
Greg Fenton

Hi, everybody ! We discovered a trouble by using ASA 8.0.2 (4339). When connecting to a database server, running ASA 8, with interactive SQL client...

jdlevet

01-09-2004 10:09 AM
Greg Fenton

Hello, Is it recommended to have PowerDesigner do the schema work instead of manual isql? I only find it simple to use PowerDesigner on the initial...

Jayvee Vibar

01-09-2004 09:57 AM
pascal.

I have a process start time field like 2004-01-09 05:04:25.000. I have another field that is the total time (hrs/mins) that the process will take to...

Ted Davidson

01-09-2004 09:44 AM
Paul Horan[TeamSybase]

I have been told http://www.singingsql.com/ and the oreilly book SQL Tuning by dan Tow is the last word on improving plans. FWIW

Karel van der Walt

01-09-2004 09:21 AM
Glenn Paulley

Hi all and happy new year, I plan to take our existing Sybase 703 build #2079 installations up to 704 win32 ebf 3495. My question is: apart from...

Russell J Morgan

01-09-2004 08:40 AM
Russell J Morgan

Is there any issue with the fact that the DB was originally created with DBEng8, but being run with DBSrv8 ? TIA, -- Kumar Manuel

Kumar Manuel

01-09-2004 08:17 AM
Chris Keating \(iAnywhere Solutions\)

Hello All, Can someone help me out with this one please... Just uninstalled and old version of ASA 8.0 and then tryied to install a fresh copy...

Gary McDonald

01-09-2004 06:17 AM
Gary McDonald

A client of ours who develops in Java (1.4.2) has reported that since upgrading to ASA 802 they frequently have problems when trying to connect to...

Mark v Niekerk

01-09-2004 03:59 AM
Mark v Niekerk

Hi, we are running ASA7 on a Novell Netware 4.11 server. Every couple of days, the DBSRV7.NLM process hangs. Any help to solve this would be highly...

Paul Hoepping

01-09-2004 02:15 AM
Paul Hoepping

A client server run out of space and the database wouldn't come up again. It crashes with the Assertion 100101 - File is shorted than expected The...

Ruben Sanchez

01-08-2004 04:46 PM
Chris Keating \(iAnywhere Solutions\)

This problem seems to occur only on win2k terminal server machine. In the ODBC setup, i have enabled Auto-Start. Auto-Stop has been turned off. I...

AJ

01-08-2004 03:32 PM
AJ

The detail create table ASSETCLASS ( ASSETCLASS char(2) not null, DESCRIPTION char(50), DEPRECIATIONMETHOD...

Karel van der Walt

01-08-2004 02:18 PM
Karel van der Walt

Hi, I have the following query SELECT anc.group_res_id, (SELECT s.res_id FROM Scope s WHERE s.precedence =...

zihong

01-08-2004 01:17 PM
zihong

The What's New and Behaviour Changes sections for 7.0.4 don't seem to exist in any recent Help file... is there anything important...

Breck Carter [TeamSybase]

01-08-2004 01:15 PM
Nick Elson

Still in the learning curve here... no reference to this in the On-Line DB Admin Guide My DB reports: Database file...

Kumar Manuel

01-08-2004 11:18 AM
Kumar Manuel

Hi, I have a slightly different requirement -- the scenario -- In an enterprise, sales persons carry laptop as well as Pocket PC. There is an...

Asim

01-08-2004 10:27 AM
Greg Fenton

Hi, I'm looking for a way to emulate oracle sequences as near as possible in ASA 9. I don't want to use autoincrement columns because I plan to use...

Chris Werner

01-08-2004 10:24 AM
Bruce Hay

Are there any problems with saving values with apostrophies in them to char and or varchar feilds? I am using ASA 8. My notes are not clear on...

Woody Splawn

01-08-2004 07:14 AM
David Kerber

Sybase Inc. (SY: NYSE) By JMP Securities ($21.64, January 6, 2003) WE ARE UPGRADING our rating on shares of Sybase Inc. from Market Perform to...

Breck Carter [TeamSybase]

01-08-2004 06:33 AM
Breck Carter [TeamSybase]

Is there a way to determine the current publisher by means of a stored procedure or SQL statement? I'm using ASA 8.0.1 Thanks, Arnoud

Arnoud Oortwijk

01-08-2004 06:28 AM
Breck Carter [TeamSybase]

Hi, Are there any known problems having ASA and ASE running on the same windows 2000 host? Can it be done and are there any issues that need to be...

Colin Jones

01-08-2004 06:19 AM
Breck Carter [TeamSybase]

I hope I can get help on this from someone out there. OS: Windows 2000 SP3 ASA version: 8.0.2.4339 Description of Problem: We're trying to get...

Ollie

01-07-2004 04:15 PM
Glenn Paulley

I am in the process of upgrading our application which currently uses Sybase SQL ANywhere 5.5. Eventhough version 9.0 is the latest version, we want...

Lorraine Ford

01-07-2004 04:07 PM
Thomas Kehl

I have an application that was recently upgraded from PB 6.5.1 to PB 8.0.3 and from ASA 5.5.04 to ASA 8.0.2. The application is written so that it...

Mike Sutton

01-07-2004 03:12 PM
Mike Sutton

New User Questions - 1. I know it's someplace in the manuals, but I can't seem to find how to change the page size. The DB reported "Page size too...

Kumar Manuel

01-07-2004 01:28 PM
Breck Carter [TeamSybase]

I have a SQL Anywhere 9.0 database where I would like to setup a proxy table to a SQL Server database. The SQL Server table has a datetime column. ...

Rebecca Fahrmeier

01-07-2004 12:59 PM
Jason Hinsperger

I am having troubles when multiple databases are started on server. Client connection gets wrong database context... Eugene.

Eugene V. Goldberg

01-07-2004 10:53 AM
Greg Fenton