This content has been marked as final. Show 1 reply
When you use DG4ODBC, then all details about the foreign database are located in the odbc.ini file hence you only need to change the odbc.ini file.
Here make sure that you adopt the host, port and database settings and verify with an ODBC test utility (for example isql) that you can connect to the correct server/database.
Just in case the new database uses a different username and password to log into the Sybase database you also have to drop and recreate the database link.