Linked Server II, using MS SQL7

The server has, for reasons of work, tried a SQL 7 join with Oracle to access Oracle's database methods directly in SQL7, as a simple way to do this, under other people's supervision.

The linked server was used to directly connect to each other's database.

First, install the Oracle client on the SQL Server and set
Second, and then open Enterprise Manger, the same way as yesterday into the Add Linked server window
Third, enter the server name to use in the linked server box, and the server name may be named arbitrarily, but not with the existing remote server or linked server.
Select "Other DATA SOURCE" in the server area
V. Provider name Select Microsoft OLE DB Provider for Oracle
Six, enter "Oracle" at Product name
Vii. Enter the server name set in the Oracle client program at data source
Eight, enter "MSDAORA" note in provider: Oracle is this, can't change
IX. Select RPC and RPC out in the server Opentions area
Ten, then switch to safety (security), according to the actual settings.
(I choose "THEY will is mapped to" and enter the account number and password)
Xi. Click OK to complete Setup

I set the success by this step, however, due to the time and conditions of the problem, has not continued to try other settings, if you have such a condition, please try other options to see what the difference, try to finish the steps and results to me a copy.

It is also necessary to note that the stability of this connection is still possible, in the year after the set up, only because the other server problems reset once, there is an Oracle client was accidentally deleted by the administrator file, and reset once again, and then there is no problem, and speed also can, a process, It takes 0.1 seconds to execute on Oracle client, and it takes about 0.2 seconds to execute via linked server.

I'll write to you tomorrow. The same settings are set using the SQL7 system procedure.

The above tests were successful on Unix+oracle7 and Nt4+sp5+sql7.