SQL Server to Sybase Connection Server Implementation
Author: CCBZZP interconnection of different database platforms generally called heterogeneous database services, can now achieve such heterogeneous interconnect between all major databases, but the manufacturers not the same as the specific implementation technology, such as: in SQL SERVER It is called Linked Server, and Internet interconnection with other databases is implemented via ODBC.
The test environment of this article is: operating system: Windows2000 Server (Traditional system)
Installing Database: SQLServer2000 (English) and Sybase8.0 Client (English)
Specific implementation steps: 1. Requires installing Sybase8.0 client software and SQLServer2000 software on your PC. 2. Configure Windows ODBC Data Source: Start Menu - "Program -" System Management Tool - "Data Source (ODBC) -" Enter User DSN or System DSN can: Add - "Select Adaptive Server Anywhere8.0- "Custom Data Source Name (randomly, SybaseTest) -" Database Name (must!) - "OK is done.
3. Select the data source name just configured, select the configuration, and jump out of SybaseTest Messages:
THE DATA SOURCE IS Not Connected. Connecting to the Data Source Will Provide Useful Information During Configuration. WOULD you like to connect to the data source?
Select Yes (OK or confirmation)
Enter the Connect to Sybase Database screen:
User ID: Enter the user of Sybase Database
Password: Enter the password of the user of Sybase Database
Connection Mode: You can choose the default Share mode
Select OK (confirm)!
Configure and test ODBC!
4. Configure the connection server in SQLServer2000: Enterprise Manager - "Security -" Connection Server - "Right click New Connection Server -" Define Connection Name; Select another data source; specify the program name: Sybase Adaptive Server Anywhere Provider 8.0; The product name can not be filled; the data source specifies the data source name that is just defined in the odbc; the provider string is filled in in the following format: user ID = username; password = userpasswd (or press UID = UserName; PWD = Userpasswd), The username and password here correspond to the username and password in the Sybase database you want to connect - "In this security context: Set the SYBASE database username and password -" Server Options tab can be default . 5. All preparations are all completed! In SQLServer Enterprise Manager - "Security -" Connection Server Opens the Junited Connection Server - "Click on the table, you can see all the table names owned by the Sybase database user in the right window, but you can't view it here. Record of the table, this need to be implemented in specific SQL in the query analyzer of SQ Server! When accessing the table, the format is: [Connect Server Name] .. [Sybase User]. [Type]. More detailed use is not described here.
In the future, add it!
