HI, I'm new to sybase. I had some problem to setup connection from client to server. Following is my environment. Server: ASE version 9.0.2+ AIX...

jane

10-31-2003 10:24 AM
jane

Hi, first of all I would to thank you in advance... Here's my problem:

Pedro Mendonça

10-31-2003 09:23 AM
Pedro Mendonça

Hi! A customer wants me to extract data of a sybase database (.db-file). I've been looking at sybase.com but cant' find any utility to use. Can...

Ronald

10-31-2003 08:31 AM
Ronald

Hi, We have Web.sql 1.0b3 (along with NCSA HTTPd NCSA/1.5.0c) under Sun Solaris 2.8 environment. It is no longer support, how can I migrate it to...

Hoang C

10-30-2003 07:01 PM
Michael Peppler

I use bcp in to import the table from a file and bcp can complete and show me all the statistic with return code= 0. When I check the table right...

Kenneth

10-30-2003 06:05 PM
Kenneth

I am attempting to run a stored proc that inserts a row into a table. I get the following error message: Object 352004285 specified as a default for...

Nuggy

10-30-2003 05:06 PM
Nuggy

I do have the the same problem! Could you solve it? I googled a lot, but the only thing I could finde was this threat. So I'd be happy if anyone...

Clip

10-30-2003 09:13 AM
Clip

Hi all, I am trying to combine multiple rows value of a column into one. For example, col1 col2 col3 col4 1 a 5 b 1 a 3 c 1 ...

santosh94538@yahoo.com

10-30-2003 05:27 AM
Karl Ritter

Hi, I need to build an application in VB that reads data from ASA 6.0. I checked Sybase site, it says only ASA7.0 can use ADO/OLE DB, does that mean...

wq

10-29-2003 01:38 PM
wq

Hi. Is it possible to connect from Linux /java application to SQL Anywhere 5.xx ? I've read an article: http://www.sybase.com/detail?id=47874 but...

kostya

10-29-2003 05:59 AM
kostya

Voor een goede klant van ons in de Randstad ben ik op zoek naar een ervaren Sybase/SQL server ontwikkelaar met kennis van de volgende...

ender

10-28-2003 07:18 PM
ender

hello. I'm looking for a way to drop indexes which are not used by my application. does someone know how to do that?

stephane

10-28-2003 08:26 AM
Carl Kayser

Adaptive Server Anywhere Extraction Utility Version 8.0.2.3608 Hi, We are replicating data between ASE 12.5 & ASA 8 and we have a problem while we...

Hoang C

10-27-2003 09:26 AM
Hoang C

Hi, I recently installed ASE 12.5 (on solaris8, 32bits). To make use of the increased limits, I also downloaded the latest version of sqsh -...

Ashish

10-27-2003 08:47 AM
Michael Heaney

Im in the initial stage of possibly looking for a Sybase DBA responsible for porting databases from one server to another. Such as HP/UX to HP/UX or...

Tim Hoffman

10-26-2003 12:30 AM
Dale Kerr

Dear Friends, I am having a table with one billon rows. I want to update two columns of the table which don’t have index . Query is going for...

Lalit

10-24-2003 07:12 PM
Roy Stewart

Very simply question: how can I control the widths of columns returned by a select statement? Is it an isql option (TRUNCATION_LENGTH looks...

David

10-24-2003 07:06 PM
Roy Stewart

Hello everyone! I'm from El Salvador and i have a problem, i have a sybase system running on windows 2000 server, probably a programmer drop...

becker

10-24-2003 06:59 PM
Roy Stewart

look at the last line in the error log: 00:2003/08/14 07:08:06.57 server Error: 1601, Severity: 21, State: 3 I dont understand why did i get this...

ofer

10-24-2003 06:44 PM
Roy Stewart

Hello, Does anybody know what is the documented and known behavior of inserting/updating binary columns using host variables from a client to...

Aakash Bordia

10-24-2003 01:53 PM
Aakash Bordia

Hello Group, we have a table called catalog which has all the linkage between products and categories. The structure is: productnr varchar catalognr...

Manuel Blechschmidt

10-24-2003 12:05 PM
Manuel Blechschmidt

I have a table with an existing primary key constraint which uses a nonclustered index. I'd like to change this to a clustered index, but without...

Ed Avis

10-24-2003 05:12 AM
Ulrike Zintz

I have 2 jobs run in parallel, each has it's own input file and bcp into it's own table, the bcp show has complete successful and so to the return...

Kenneth

10-24-2003 04:20 AM
Kenneth

Dear all, I have a table T with numeric fields A and B. Now I want to update a column in the same table according to the following logic : A ...

Puneet Vyas

10-23-2003 04:27 PM
--CELKO--

We are replicating data between ASE 12.5 & ASA 8 and we have a problem with the single and double quoted identifiers We can set this option to OFF in...

Hoang C

10-23-2003 08:51 AM
Willie Kraatz

Hi. We'd like to move all our Sybase installation from an old RS/6000 box to a new one. We run Sybase 11.5 on IBM AIX box. All our database is on raw...

Hiroshi

10-23-2003 08:30 AM
Pablo Sanchez

Hi, I am trying to recover my SYBASE databases and I am stuck with the recovery of one of them. My problem is that I don't know how to create him...

Yahav Tako

10-23-2003 01:29 AM
Ulrike Zintz

I never mixed data and log devices before - but I'm sitting here wondering why I should care at this point. The new disk system on this Sunfire 880...

r l reid

10-22-2003 05:03 PM
Ibrahim DOGAN

I am running dbsrv7 on Win2k and am trying to find a way that disallows non-administrative Win2k users from successfully clicking "end process" in...

Marshall

10-22-2003 08:08 AM
Marshall

hi, I was trying to apply a patch (ebf11441 for ase12.5, solaris 32bits) when i got a checksum error in tar. has anybody else noticed this ? any...

Ashish

10-21-2003 08:53 PM
Ashish

Hi, I am using version 12.0 of SYBASE on Sun Solaris 5.6 I have made an openserver using the libsrv provided in the sybase package. And after having...

julien

10-21-2003 05:50 PM
Michael Peppler

Hi, I had installed ASE 12.5 today. Then I saw on the web that the latest EBF (for 32 bits, solaris) is EBF 11441: 12.5.0.3 ESD#4 which was released...

Ashish

10-21-2003 05:04 AM
Ashish

Guys, I am new to Sybase and trying to figure out how to get data from a table into a flat file based on certain condition. For example, Put all the...

hs

10-20-2003 07:15 AM
Brian Ceccarelli

Sybase Australia User Group Meeting - Sybase presents HA demo Date: 22-10-03 - 6:00PM at Sybase office in North Sydney Pizzas and Drinks will be...

willy_and_the_ci

10-20-2003 01:10 AM
willy_and_the_ci

I have a large production database that I need to run dbcc on. As far as I know, dbcc checkdb checkalloc have never been run on the databases so the...

Thomas Richards

10-19-2003 08:33 AM
Joe Woodhouse

Hello, how can I get 6 random rows from a Sybase server. SELECT * FROM table ORDER BY RAND() doesn't work. Greetings Manuel

Manuel Blechschmidt

10-18-2003 12:16 PM
Manuel Blechschmidt

Hi, I have an openclient connected to an openserver. When I try to call a RPC from my client to the server, I check that the client hasn't lost the...

julien

10-17-2003 10:02 AM
Michael Peppler

Hi Folks, Is there a guide giving tips on how to best tune Sybase(any version of ASE) on linux?? I have seen quite a few people talking about it...

Subhas

10-16-2003 10:56 AM
Michael Peppler

Hi , We have a client in Tanzania running our system on SYBASE 12.5 on a HP Unix box. We need to restore the database dump(on tape) on our OpenUnix...

Rudie

10-15-2003 10:24 AM
Michael Peppler

The running plat form is as follows; Database is Sybase Application is Equinox Operating System is Unix Tru64 Processor speed about 3gb The...

Akalo Tonny

10-15-2003 06:13 AM
Carl Kayser

Our ASE server is 12.5 and our rep server is 12.5 running on AIX. We have replication working between many servers. Our current issue is that rows...

Kermit Lowry

10-15-2003 05:51 AM
Kermit Lowry

I am running ASE 12.0 on AIX 4.3.3 ML10. I notice that the cpu utilization for the dataserver is very steady, e.g. 10.2 - 10.5% in my system no...

Kenneth

10-14-2003 11:40 PM
Joseph Weinstein

Hi all. A few quick question regarding cursors. What is the maximum number of cursors that a process can have open at a point in time? And what is...

Peter

10-14-2003 01:19 AM
Peter

Gestalt Corporation announces the release of STEP FORWARD - a multi-platform development framework for database-centric applications. STEP FORWARD is...

Alex Molochnikov

10-14-2003 12:17 AM
Alex Molochnikov

"Steve" <stevesusenet (AT) yahoo (DOT) com> wrote Quite right: see www.sypron.nl/ase_free for information about free versions of ASE. For a bit of...

Rob Verschoor

10-13-2003 12:07 PM
Rob Verschoor

Hi, I am accessing data from sql advantage and also from unix session. I got the same error from both. The error message is: "Character or binary...

Amy

10-13-2003 07:00 AM
Carl Kayser

Hi, We use sybase 12.0 and over time we have a table that has collection of transactions (for statistical reports). It has about 20 mil rows. About...

Anr

10-13-2003 06:44 AM
Jacques d'Hondt

Hello, has someone a little C program to test if a sybase database is online? The input parameters should be 'Database server name', 'User...

Edouard

10-13-2003 03:16 AM
Rob Verschoor

How could i know what is the backfile size before i run backup? i run sp_spaceused and sp_helpdb dbname but the file size allways bigger than the...

ofer

10-12-2003 11:50 AM
ofer

Dude (Anthony Mandic), seek professional psychiatric help. ISUG has chosen a technical director with 1+ screws loose. ---- : Newsgroups:...

Anthony Mandic

10-12-2003 12:43 AM
Anthony Mandic