SQL Server to SQLBase Connection Server Implementation
Author: CCBZZP
The interconnection of different database platforms is generally called the heterogeneous service of the database. Such a heterogeneous interconnection can now be achieved, only the specific implementation technology of each manufacturer is different, such as: in SQL Server is called Linked Server, implements interconnection with other databases via ODBC.
The test environment of this article is:
Operating system: Windows2000 Server (Traditional System)
Installation Database: SQLServer2000 (English) and SQLBase7.5 Client (English)
Specific implementation steps: 1. Requirements to install SQLBase7.5 client software and SQLServer2000 software on your PC. 2. Configure Windows ODBC Data Sources: Start Menu - "Program -" System Management Tool - "Data Source (ODBC) -" Enter the Configuring User DSN or System DSN: Add - "Select Centure Sqlbase 3.01 32-bit Drivers-NT & WIN95- "Enter the ODBC SQLBase Driver Setup screen:
Custom Data Source Name (Free, Sqlbasetest) - "Database Name (must!) -"
Server Name: Enter SQLBase Database Server name
Default User Name: Users to enter SQLBase Database Others Select the default value, select OK (confirm)!
Configure and test ODBC!
3. Configure the connection server in SQLServer2000: Enterprise Manager - "Security -" Connection Server - "Right click New Connection Server -" Defines the Name of the Connection; Select another data source; specify the program name: Microsoft Ole DB Provider for ODBC DRIVERS; 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 SQLBase database you want to connect - "Security tab: Settings with this security context, and enters SQLBase database username and password -" Server Options tab can be default - "OK . 4. Preparations are all completed! In SQL Server Enterprise Manager - "Security -" Connection Server Opens the Junited Connection Server - "Click on the table, you can see all the table names owned by the SQLBase 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] .. [SQLBase User]. [Table Name]. More detailed use is not described here.
In the future, add it!
