I have installed 9.0. When I open Sybase Central and try to connect to a 5.5 database I am informed that the database must be unloaded and reloaded....

Bill Urbanovsky

12-18-2003 10:41 AM
Chris Keating \(iAnywhere Solutions\)

Greetings, I am trying to execute a HUGE SQL Statement (around 40000 lines of code containing create tables, alter tables, constraint declarations,...

Orlando Ribeiro

12-18-2003 10:11 AM
Chris Keating \(iAnywhere Solutions\)

I have had a very odd problem, and thus far have found two solutions. The problem is, I don't really understand either solution, other than...

Mark Hampton

12-18-2003 09:36 AM
Mark Hampton

Hi, We recently upgraded our live database to ASA 9 from ASA 6. It seems although everything is working fine a database extract on our biggest table...

Roel Sergeant

12-18-2003 08:49 AM
Roel Sergeant

I have seen in other threads that multiple version of ASA can be installed on the same system. What I need to know is if the Shared Files directory...

Michael L. Sorensen

12-18-2003 06:24 AM
Breck Carter [TeamSybase]

To All: I have a need for some "older" dll's I have a license for version 8.0 but need the following stuff from version 5.5 or 6.0 can anyone find...

Brian B

12-18-2003 06:17 AM
Breck Carter [TeamSybase]

OK, I've read it twice and still don't see a question asked :) Breck May Be Having A Senior Moment On 4 Dec 2003 08:29:55 -0800, "Russell J...

Breck Carter [TeamSybase]

12-18-2003 05:12 AM
Russell J Morgan

According to the documentation for version 9 "There are two kinds of upgrade possible with version 9: Upgrade the database - Use the Upgrade ...

Bill Urbanovsky

12-17-2003 06:00 PM
Breck Carter [TeamSybase]

all (sybase engineers), SQL LOG file: 1. the beginning of each line has a month and day (mm/dd) but no year 2. in a line such as this: 03/11...

_alan

12-17-2003 04:17 PM
_alan

I am running dbunload with the following options: dbunload - c "uid..." -y -ar c:\unloaddir After the unload is complete, the log file is out of...

Jim Cullison

12-17-2003 01:49 PM
Bruce Hay

We have had our database server crash twice within the last couple days with full DrWatson's. As I am assuming the engine being fairly stable I...

Erik Anderson

12-17-2003 01:34 PM
Nick Elson

I have a simple PB app that connects to a dbeng7.exe engine database. I install it on clients PC as a standalone application and up to now...

Joe Coady

12-17-2003 01:15 PM
Graeme Perrow

I am seeing that Sybase clears my JAVA_HOME environment variable for new shells launched by xp_cmdshell. From a database startup event I am...

Jim Cullison

12-17-2003 01:13 PM
Jim Cullison

I have a table with 4 columns C1,C2,C3,C4 Sometimes there are selects with WHERE C1= xxx and C2 =kkk and sometimes with WHERE C3= yyy and C4...

Peter Stojkovic

12-17-2003 12:18 PM
Breck Carter [TeamSybase]

I recently downloaded and installed ASA9 EBF1250 and discovered that using 'order 0' in create trigger now causes a syntax error. No previous...

Dave Foulkes

12-17-2003 11:50 AM
Dave Foulkes

Thanks to both of you -- that's exactly what I needed. "Breck Carter " <NOSPAM__bcarter (AT) risingroad (DOT) com> wrote in message...

Kevin

12-17-2003 11:48 AM
Kevin

Currently our app is using Sybase Sql Anywhere 5.5 authenticated edition. Does such an edition for version 8 or 9 still exist? I didn't seem to be...

Arnoud Oortwijk

12-17-2003 09:19 AM
Bart van Kuijk

The IEnterprise Application now accessible . IEnterprise Application: a fast way of creation the Windows application with SQL Server...

radiy

12-17-2003 05:16 AM
radiy

Is any ony try to create a response file with the silent installation option SETUP.EXE -r with ASA8 ? I tried but the file "setup.iss" did not...

Mohammad Alhabibi

12-16-2003 08:34 PM
Lana Turner

I have read the chapter on Upgrading Version 5 Applications and am still a little confused. I know it is possible in a client/server application...

Bill Urbanovsky

12-16-2003 01:55 PM
Erik Anderson

Please recall that this is not a support channel. If you are unable to get an answer in this forum and you need to get this matter answered,...

Rich Jones

12-16-2003 01:28 PM
Chris Keating \(iAnywhere Solutions\)

Are ASA 8.0.2.3601 and 8.01.2600 .db files interchangeable? That is, can an 8.0.2.3601 .db file be read without modification by an 8.01.2600 db...

Bill McHugh

12-16-2003 12:04 PM
Chris Keating \(iAnywhere Solutions\)

I found a situation were I need to branch out from a block of code and continue at a specific block of code. GOTO statement would be ideal for this,...

Ollie

12-16-2003 12:03 PM
Ollie

Hi! We've had an installation up and running for many years, and all of a sudden 1 client cannot connect to the server. Several other clients can...

Daniel Coppersmith

12-16-2003 11:41 AM
Chris Keating \(iAnywhere Solutions\)

We are having the problem the tmp files with the following naming format, pbd##.tmp (pbd14.tmp, pbd10.tmp, etc), being created in the temp folders. ...

Joe Phillips

12-16-2003 11:32 AM
Chris Keating \(iAnywhere Solutions\)

We were going to move a very critical system running on ASA 6 to ASA 8. But now I see ASA 9 is released. Is ASA 9 extremely stable yet, or should I...

at

12-16-2003 10:06 AM
anders

If I run the following statement: --- select time1, time2 from table1 ;Output to c:\test.csv Quote '"' ALL; --- and time1 is Null it writes --- ,...

polzovatel

12-16-2003 06:40 AM
polzovatel

Hi All Another simple one perhaps? We occasionally load up a text file with a lenghty series of one-time SPs, UPDATEs, etc that we need to run on...

BH

12-15-2003 09:53 PM
Erik Anderson

The 9.0.0.1235 dbunload generates a "Check View definitions" that creates and sets a global variable called "view_not_found". What's the story here?...

Breck Carter [TeamSybase]

12-15-2003 06:21 PM
Nick Elson

Hi all Strange but true: Somewhere in the dark past, a user was set up in our ASA db (6.0.3.2747) with username = 1, password = 1 I'd like to...

BH

12-15-2003 04:27 PM
Breck Carter [TeamSybase]

After installing a new database on my ASA 9.0 server, i had to change some of it's options to allow the insertion of date's in ths 'MM-DD-YYYY'...

Orlando Ribeiro

12-15-2003 03:51 PM
Breck Carter [TeamSybase]

I was looking to find a document, white paper, or HOW TO on how to effectively implementing database security in an ASA, or any relational database,...

Phil

12-15-2003 03:15 PM
Stephen Rice

I have the following table and I need to select the rows for a specific SiteCode, ProductCode. But I only need the rows with the current price. ...

Eddie Sizemore

12-15-2003 02:11 PM
Eddie Sizemore

Just received the Developer Subscription CDs for ASA 9...but only the Windows version was included. When's the Linux version going to be...

Michael Landon

12-15-2003 01:46 PM
Orlando Ribeiro

I want to run two ASA 7 Databases on the same server. One for our timeclock app and the other for our menu system. I've been warned that it could...

aprykhus

12-15-2003 11:43 AM
Gerald Gillespie

Can anyone point me to a doc, or perhaps explain, the benefits or otherwise of running the database engine service under the Local System Account....

Justin Willey

12-15-2003 08:10 AM
Martin Baur

Hi! I just realized, that I can speed up my application (connected to the DB via a DSL-VPN) by changing the PREFETCHROWS to 100. What are good...

Claudius Schmid

12-15-2003 03:03 AM
Greg Fenton

I'm trying to install SQLA 5.5 on MS Terminal Server. It runs fine but when I try to connect a second user, it freezes the server. (The same setup...

Mike Packard

12-14-2003 07:29 PM
Mike Packard

I have a customer running ASA v8.0.2.4322 (windows environment using dbsrv8). She setup an automated backup using a "Backup" event. When the event...

David DeRam

12-13-2003 12:18 AM
Darren Cameron

Greg, thanks for replying. I ended up contacting tech support on it. It turned out that I needed a different engine name for the ENG= parameter in...

Scott Huerta

12-12-2003 07:54 PM
Scott Huerta

I am trying to do a simple connection in JBuilder to a ASA 8 DB: CLASSPATH=C:\Program...

Thom Lamb [ISUG]

12-12-2003 04:27 PM
Nate Dogg

Hi all Sometimes when my client application(2) is reset by another application(3) because of response timeout, the ASA server do not allow the...

Frank

12-12-2003 02:19 PM
Frank

Hi, I need some help in the below procedure. I have a column in the table empid the values are like 1000,2002,3000 etc...,, I want to send these...

12-12-2003 01:25 PM
Frank

Hi, My question is: does anyone know how DBBackup -l will behave if it can't write an update to the back up copy of the Transaction Log on a remote...

KeithAB

12-12-2003 11:59 AM
Keith Alexander-Buckley

Hi, I got the information that there's an EBF 8.0.2.4356 which fixes a problem we have. Can I please get an adress where to download it, as it is...

Florian Kornhoffer

12-12-2003 11:32 AM
Chris Keating \(iAnywhere Solutions\)

I have a 3rd party software that uses Sybase SQL Anywhere Network Server Version 5.5.05 Build #2817 as database. I need to deploy it to a webserver...

laxmi

12-12-2003 09:25 AM
Stephen Rice

Hello, This is my declaration of a stored function in ASA: function DBA.f_TitlePageResult(in a_start integer,in a_limit integer,in a_target...

Jayvee Vibar

12-12-2003 06:26 AM
Breck Carter [TeamSybase]

I can not start up the manage adaptive server anywhere after I have installed jre-1_3_1_09 ,why?

Gavin Yan

12-12-2003 02:50 AM
Greg Fenton

You are correct - it appears that ROLLUP is not known as a keyword in our ODBC driver, though it is a reserved word in the engine. This is being...

Glenn Paulley

12-11-2003 04:50 PM
Glenn Paulley

We recently had a database crash on our system. After restarting the server we went to look at the request log and found that it had apparently...

Erik Anderson

12-11-2003 03:47 PM
Erik Anderson