my laptop's drive just crashed but I have a recent copy of
SQL
Anywhere .db and .log files. When I toss them on another
machine, I get ODBC errors and can't connect. Ideas? Can
you just drag these two files around or do I need to do some
kind of archive or backup in Sybase Central?
Thanks, Jim

Jim wrote:
Do you have the server software installed on the new machine?
Which version of SQL Anywhere was on the previous machine?
Which version is on the current machine?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Server Anywhere 6.0 and iAnywhere 9 I've been successfully
running PB7 client-server apps, using standalone engine with
SQL 5.0 odbc. I just need to know if I can grab those .db
and .log files directly?

JIm Wheeler wrote:
Yes, the .db and .log files can be run under a newer server version.

However, the client/server protocol changed drastically between v5 and
v6, so you may find that your ODBC configuration needs to change.

Can you describe your ODBC settings?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

No-one else asked so I will...

What ODBC errors do you get since such errors can be related to
connection, syntax errors, and even more drastic problems. Without the
specifics, we will be guessing the problem and worse making
recommendations based on those guesses.


--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

************************************************** ***************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

************************************************** ***************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

************************************************** ***************************

"DBMS ODBC is not supported in your current installation."

running compiled PB7 application, which previously worked on
standalone "c:\sqlany50\win32\dbeng50.exe" It's been
working since the late 90's, on NT4 as well as XP Pro (more
recently, on the crashed laptop). While I bought iAnywhere
9.0, thinking I'd need it for XP Pro, the ODBC connection
which previously worked on both platforms was "Sybase SQL
Anywhere 5.0"

Thanks, Jim

since such errors can be

The installed standalone engine:
c:\sqlany50\win32\dbeng50.exe -c30m
with ODBC from "Sybase SQL Anywhere 5.0" on the 'system DSN
tab'

Are you sure that was the *exact* message, and it wasn't *this*
instead?...

DBMS ODB is not supported in your current installation.

PowerBuilder uses the first 3 characters of the SQLCA.DBMS = 'xxx...'
value to find the dll named pbxxx070.dll, and the above message is
produced when it cannot find that dll. Check the PB deployment folder
for pbodb070.dll; the default folder is this:

C:\Program Files\Sybase\Shared\PowerBuilder

Breck




On 28 Apr 2006 08:32:20 -0700, Jim Wheeler wrote:

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhe...ers_Guide.html
breck.carter (AT) risingroad (DOT) com