ODBC driver for SQL Anywhere 5.2

[Former Member]

We have SQL Anywhere 5.2 server running on windows NT4. We are trying to convert to dabases hosted on this server to two seperate MS SQL 2005 databases. I have the Microsoft SSMA for Sybase utility installed on an XP computer on the same network but we do not have the ODBC drivers for XP to connect to the database.

Does anyone have access to these files or know of another way to export/output the data from the source server?

[former_member188493 · Accepted solution]

I don't think there is any such thing as SQL Anywhere 5.2 but that probably doesn't matter.

If you really really really really really want to obtain ODBC access to a running SQL Anywere 5.x database from scratch, that is possible... but it might be far easier is to install SQL Anywhere 16 and upgrade the V5 *.db file to a V16 database, then run this Windows command file to do the upgrade...

(you can stop the V5.x database engine, then copy the *.db file to another computer to do this, so you don't disturb the current setup)

REM If you're a command-line kinda guy, here is my template Windows 
REM batch file run_dbunload_upgrade_v5_to_v16.bat. It does the 
REM unload-reload-all-in-one-dbunload-step, then starts dbeng16 
REM and dbisql so you can make sure the new database is up and running.

REM Be sure to stop *all* database engines on the computer you're using, 
REM before starting the upgrade.

REM dbunload...
REM -an ...  where to put new database
REM -ap ...  new database page size
REM -c ...   old database startup connection string
REM -o ...   where to put unload console display text file
REM -v       verbose mode for console display

PAUSE MAKE SURE YOU DO NOT HAVE ANY ENGINES RUNNING.

"%SQLANY16%\bin64\dbunload.exe"^
  -an ddd16.db^
  -ap 4096^
  -c "DBF=sademo.db;UID=dba;PWD=sql"^
  -o dbunload_log_sademo.txt^
  -v

PAUSE dbunload/reload done...

"%SQLANY16%\bin64\dbspawn.exe"^
  -f "%SQLANY16%\bin64\dbeng16.exe"^
  -o dbeng16_log_ddd16.txt^
  ddd16.db 

PAUSE dbeng16 started...

"%SQLANY16%\bin64\dbisql.exe"^
  -c "ENG=ddd16;DBN=ddd16;UID=dba;PWD=sql" 

PAUSE dbisql running...

[Former Member]

Sorry for wait and the confusion. I confirmed 5.2 is not correct and 5.5 is indeed the version we are using.

I would like to try ODBC drivers first to connect if anyone has them.

[former_member188493]

Send your request to my-dot-name-at-gmail-dot-com

[Former Member]

Hi.

I don't remember if powerbuilder v.5.0 includes that version of the product or a newer one.

Andreas.

[Former Member]

I may have some old drivers from an old PB8 app. Not sure they will work but you are welcome to try. let me know how I can get them to you.

Regards -