I was going to migrate an old asa 6 database.
apparently the system registry got corrupted. I could see the dataset
profile myDB in PowerBuilder in the database painter but I could not
connect. If I use the dbeng6.exe on the database file itself, I could start
it,. I can also use dbisql to connect to it

I tried from DOS Prompt
set SybPath=c:\pgmf\Sybase
reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\MyDbP"
reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\MyDbP" /v Driver /t REG_SZ /d
"%SybPath%\Adaptive Server Anywhere 6.0\win32\dbodbc6.dll"
reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\MyDbP" /v UID /t REG_SZ /d DBA
reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\MyDbP" /v Start /t REG_SZ /d
"%SybPath%\Adaptive Server Anywhere 6.0\win32\dbeng6.exe"
reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\MyDbP" /v DatabaseFile /t REG_SZ /d
"D:\data\MyDbP.DB"
reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\MyDbP" /v DatabaseName /t REG_SZ /d
MyDbP
reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\MyDbP" /v EngineName /t REG_SZ /d
MyDbP
reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\MyDbP" /v AutoStop /t REG_SZ /d Yes
reg add "HKLM\SOFTWARE\ODBC\ODBC.INI\MyDbP" /v Integrated /t REG_SZ /d Yes


But I still have trouble. When I tried to use the ODBC data source
administrator, select MyDB and clicked configure, I got
---------------------------
Microsoft ODBC Administrator
---------------------------
The setup routines for the Adaptive Server Anywhere 6.0 ODBC driver could
not be found. Please reinstall the driver.
---------------------------
OK
---------------------------
the inital problem connection was with PB7
What must I do to fix the problem short of re-installing the asa? I have
the EAS4.5 developer version and PB 7 and 9 installed

SybPath must be incorrect or defined as an user variable. The error
being reported simply indicates that the path and file name of the
driver is not valid.

BTW
MyDbP is the DSN name that you are defining but you claim to be using
MyDB dsn. I assume that is a typo?
--

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

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

I found a work around. import the ODBC settings for the asa6 and the
relevant dataset, making appropriate adjustment to locations of programs and
database files

"JG" <no (AT) Email (DOT) pls> wrote