Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Upgrade problems

3 posts in General Discussion Last posting was on 2003-04-04 18:16:01.0Z
Dave_Parker Posted on 2003-04-04 18:10:26.0Z
From: Dave_Parker
Date: Fri, 4 Apr 2003 14:10:26 -0400
Newsgroups: ianywhere.public.general
Subject: Upgrade problems
Message-ID: <39E611C9B0C725FD0063D4FD85256CFE.0063D51885256CFE@webforums>
Lines: 52
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:862
Article PK: 3968

I am trying to upgrade (don't laugh) a SQL Anywhere 5.0 database to ASA
8.0. What has worked for me so far is this:

1. from command prompt, start database engine
2. go into database with ISQL to fix a data problem
3. unload data to text
4. delete 5.0 database, initialize 8.0 database with same name, delete 5.0
dsn, add 8.0 dsn
5. start database engine
6. open ISQL and run reload.sql
7. run application (PB 6.5) and make sure database connection works

We have a little over 20 locations and each has its own local database.
I've got two problems that I can't fix:

1. On startup of application, DB Engine starts, then 4 errors come up and
the program quits. The errors look like this:

Select Error: SQLSTATE = 37000
[Sybase][ODBC][Adaptive Server Anywhere]Syntax error or access
violation near '?' in ?[?]?+??????????????++?...

2. From the command prompt, I start the database engine then try to connect
to the database in ISQL with the command dbisql -c
dbn=dbname;uid=xxx;pwd=xxx. ISQL opens, but doesn't connect. Instead I
get the window that would be there if I just opened ISQL from the desktop.
I make sure the everything is set correctly, then click OK. An error
window pops up:

Not enough information was given to connect to or start the
database.

To connect to a server, enter the name or network address of the
server in the "Server name" field. If you are connecting to a local
server, you can leave this field blank, but you must specify a database
file, or start the server yourself first.

When I click Show Details, the following appears:

Connection parameters:
User=xxx
Password=xxx
DBN=dbname

I've also tried connecting to the database file without the engine running,
with the same result. As well, I've tried using the DSN both with and
without the engine running. The same thing happens, but with a line at the
bottom: DSN=dsname. What really gets me is that right after I get that
error, I can start up the PB application, which connects through the exact
same DSN, with no problem whatsoever.

I'm really stumped on these. Thanks in advance for any help.

--Dave


Robert Waywell Posted on 2003-04-04 18:08:37.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <39E611C9B0C725FD0063D4FD85256CFE.0063D51885256CFE@webforums>
Subject: Re: Upgrade problems
Date: Fri, 4 Apr 2003 13:08:37 -0500
Lines: 90
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <O29mfXt#CHA.331@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:864
Article PK: 2772

For #2, try specifying the server name as well as the dbname. You can double
check the engine console to verify that the server and database names are
what you expect them to be.

For #1, what exact version and build number of 8.x are you using? If you are
at 8.0.0 GA, then testing with 8.0.2 should at least get you a proper error
message back.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Dave_Parker> wrote in message
news:39E611C9B0C725FD0063D4FD85256CFE.0063D51885256CFE@webforums...
> I am trying to upgrade (don't laugh) a SQL Anywhere 5.0 database to ASA
> 8.0. What has worked for me so far is this:
>
> 1. from command prompt, start database engine
> 2. go into database with ISQL to fix a data problem
> 3. unload data to text
> 4. delete 5.0 database, initialize 8.0 database with same name, delete 5.0
> dsn, add 8.0 dsn
> 5. start database engine
> 6. open ISQL and run reload.sql
> 7. run application (PB 6.5) and make sure database connection works
>
> We have a little over 20 locations and each has its own local database.
> I've got two problems that I can't fix:
>
> 1. On startup of application, DB Engine starts, then 4 errors come up and
> the program quits. The errors look like this:
>
> Select Error: SQLSTATE = 37000
> [Sybase][ODBC][Adaptive Server Anywhere]Syntax error or access
> violation near '?' in ?[?]?+??????????????++?...
>
> 2. From the command prompt, I start the database engine then try to
connect
> to the database in ISQL with the command dbisql -c
> dbn=dbname;uid=xxx;pwd=xxx. ISQL opens, but doesn't connect. Instead I
> get the window that would be there if I just opened ISQL from the desktop.
> I make sure the everything is set correctly, then click OK. An error
> window pops up:
>
> Not enough information was given to connect to or start the
> database.
>
> To connect to a server, enter the name or network address of the
> server in the "Server name" field. If you are connecting to a local
> server, you can leave this field blank, but you must specify a database
> file, or start the server yourself first.
>
> When I click Show Details, the following appears:
>
> Connection parameters:
> User=xxx
> Password=xxx
> DBN=dbname
>
> I've also tried connecting to the database file without the engine
running,
> with the same result. As well, I've tried using the DSN both with and
> without the engine running. The same thing happens, but with a line at
the
> bottom: DSN=dsname. What really gets me is that right after I get that
> error, I can start up the PB application, which connects through the exact
> same DSN, with no problem whatsoever.
>
> I'm really stumped on these. Thanks in advance for any help.
>
> --Dave


Dave_Parker Posted on 2003-04-04 18:16:01.0Z
From: Dave_Parker
Date: Fri, 4 Apr 2003 14:16:01 -0400
Newsgroups: ianywhere.public.general
Subject: Upgrade problems -- addendum
Message-ID: <6A0A41C47043FED0006457E285256CFE.0063D52785256CFE@webforums>
References: <39E611C9B0C725FD0063D4FD85256CFE.0063D51885256CFE@webforums>
Lines: 4
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:863
Article PK: 4013

Forgot to mention that each problem has only happened at one location. The
rest of the upgrades have gone smoothly, according to the steps listed.

--Dave