Use MySQL 7 connector server article 2 _ MySQL

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.