For work reasons, I tried to connect SQL7 to ORACLE and directly access the ORACLE database in SQL7. below I will briefly describe this method. At that time, the slave server was used to directly connect to the peer database. 1. first install the ORACLE client on the SQL Server, and set it. 2. then open ENTERPRISEMANGER, which is the same as yesterday's SQL Server.
I tried to connect SQL 7 to ORACLE and directly access the ORACLE database in SQL 7 for work reasons. here I will briefly describe this method.
At that time, the linked server was used to directly connect to the peer database.
1. first install the ORACLE client on the SQL Server and set it
2. open enterprise manger and enter the add linked server window in the same way as yesterday.
3. enter the name of the SERVER to be used in the linked server box. the name of the SERVER can be named according to naming rules, but it cannot be the same as that of an existing remote server or linked server.
4. select "other data source" in the SERVER area"
5. select Microsoft ole db Provider for Oracle for Provider name"
6. enter "Oracle" in Product name"
7. enter the server name set in the Oracle client at Data source.
8. enter "MSDAORA" in the Provider. note: This is the case in ORACLE and cannot be changed.
9. select "RPC" and "rpc out" in the Server opentions area"
10. switch to Security according to the actual settings.
(I select "THEY WILL BE MAPPED TO" and then enter the account and password)
11. Click OK to complete the settings.
I have successfully set this step. However, due to time and condition problems, I have never tried other settings. if you have such conditions, please try other options, I hope to send me a copy of the steps and results after the test.
It should also be noted that the stability of such connections is still acceptable. in the year after the connection is set, it is reset only once because of a problem with the other server, another time is that the ORACLE client was accidentally deleted by the administrator and reset the file again. Then there was no problem and the speed was okay, it takes about 0.1 seconds to run on the ORACLE client and about 0.2 seconds to run on the linked server.
Tomorrow, let's write down the above method for setting the system process with SQL7.
The preceding test is successful on UNIX ORACLE7 and NT4 SP5 SQL7.