on 08-22-2014 10:57 PM
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?
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi.
I don't remember if powerbuilder v.5.0 includes that version of the product or a newer one.
Andreas.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 -
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.