Implementation of SQL Server to SQLBase connection server

server| Server


the implementation of SQL Server to SQLBase connection server





 





Author: Ccbzzp





 





the interconnection of different database platforms is commonly referred to as the heterogeneous services of database, now each large database can achieve such heterogeneous interconnection, but the specific implementation of various vendors, such as: In SQL Server called linked server, through the ODBC implementation and other databases Interconnection.











the test environment for this article is:





operating system: WINDOWS2000 SERVER (traditional system)





Installation Database: SQLSERVER2000 (English) and SQLBASE7.5 client (English version)





 





specific implementation steps:


1. Requires the PC to install SQLBASE7.5 client software and sqlserver2000 software.


2. To configure Windows ODBC data source:


Start Menu-"assembly-" System management Tool-"data source (ODBC)-" Enter the configuration User DSN or System DSN can be: Add-"Select Centure sqlbase 3.01 32-bit drivers-nt &win95-" into the ODBC SQLBase DRIVER Setup screen:





Custom data Source name (optional: sqlbasetest)-"Database name (required!) ）—》





Server Name: Enter the server name for SQLBase database





DEFAULT User NAME: Enter users of SQLBase database





other Choose the default value, select OK (confirm)!





Configuration and test ODBC complete!








3. To configure a connection server in sqlserver2000:


Enterprise Manager-"Security-" Connection server-"right" New connection server-"Define the connection name, select a different data source, and specify the program name: MICROSOFT OLE DB PROVIDER for ODBC DRIVERS; Product name is not filled; Data source Specifies the name of the data source that is defined in ODBC just now; the provider string is filled in the following format: User id=username; PASSWORD=USERPASSWD (or in the following format: Uid=username; PWD=USERPASSWD), where the username and password correspond to the user name and password in the SQLBase database to which you want to connect-security tab: Set in this security context, and enter the SQLBase username and password-the Server Option tab page can be determined by default-".


4. All preparations are complete! In SQL Server Enterprise Manager-"security-" connect the server to open the newly built connection server-"Click on the table, you can see in the right window of the SQLBase database users have all the table names, but here is not to view the records of the table, This needs to be implemented in the Sqserver Query Analyzer with specific SQL! When accessing a table, use the format: [Connect server name]. [SQLBase user]. [Table name]. More detailed and specific use here no longer repeat.





later add!