Connect to SQLserver through oracle-use an ODBC instance

I operate on the same server according to the link above. I succeeded, but I operate on the same server (that is, SQL Server and oracle are on the same machine, and different machines are waiting for experiment, all are 32-bit machines ).

However, a problem occurs during the operation.
1, 32-bit SQL Server, 64-bit oracle, I had a good job for half a day, can tnsping, but always report ora-28545.
2. You can see many databases in the sa Logon of sqlserver. You need to select a database when creating odbc. If no database is selected, the database is default (which database is unknown by default ). Make sure the test is successful.
3. When tnsname. ora is used, what is the host name of sqlserver? Or oracle machine name? Verify this.

The steps can be divided into five:

The Code is as follows:	Copy code
1. Establish ODBC and system DSN. 2, $ oracle_home/hs/admin/init <sid>. ora 3, $ oracle_home/network/admin/listener. ora, add a listener, remember to restart. 3, $ oracle_home/network/admin/tnsname. ora, add TNSNAME 4. CREATE PUBLIC DATABASE LINK 5, select * from dd @ db_link