This discussion is archived
1 Reply Latest reply: Jan 27, 2013 10:21 PM by kgronau RSS

What needs to change when moving system using Gateway ODBC?

tx103108 Newbie
Currently Being Moderated
Oracle 11gR2
Linux 6.x
Sybase 12 (on Windows)
unixODBC 3.2.x
Sybase Client 12
------------------------

Given the following files or structures that are important to the proper operation of the ODBC Gateway connecting to a remote Sybase database:

listener.ora
tnsnames.ora
initmydblink.ora ( my version of the initdg4odbc.ini )
dblink (not a file but the dblink in the Oracle database)
odbc.ini
odbcinst.ini

What files (and what properties within those files) may/must be changed if the remote Sybase db and system is different (i.e. the Sybase database source has been changed to something 'new')?

For example, I can that the odbc.ini file is going to have to be alterer to point to the new database server IP address, database port, database name?
But is that all?

Thanks.
  • 1. Re: What needs to change when moving system using Gateway ODBC?
    kgronau Guru
    Currently Being Moderated
    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.

    - Klaus

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points