Shulou(Shulou.com)05/31 Report--

How to access the table in Sybase in SQL Server. For this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

Q: how should SQL Server access tables in the Sybase database?

A: the specific methods are as follows:

1: install the Sybase client

Requirements for the version:

Sybase Client 11.9.2 for NT

1.1After the installation is complete, run-> Program-> Sybase- > Dsedit

Select 'Server Object',- >' Add' from the menu to enter a service name such as 1.70

1.3Then select '1.70' in the Server list, double-click on the right dialog box server address bar, and select add in the Network Address Attribute dialog box to fill in the ip address, such as 132.228.1.70 Magi 4300 OK OK

1.4: select the Ping Server button on the toolbar to test if you can reach the server (the red lightning button)

2: create DSN in ODBC >

Administrative tools-> data Source ODBC

Create a new system DSN with the name set to 1.70

Select the 'Sybase System11' data source driver' in the create New data Source dialog box

DSN datasouce name of General attribute: fill in 1.70

Database: enter the name of the sybase database

Make sure to save

3: set up a linked server

Enterprise Manager-> Security-> build linked Server-> New linked Server

3.1: in the general label column

Name Sybase

Select a different data source for the server type, and select from the name of the provider

Microsoft OLE DB Provider FOR ODBC

Data source: fill in DSN name 1.70

3.2: in the security column

Log in locally and enter sa

The remote user and remote password enter the username and password of the sybase

3.3: establish a connection using this security context

Log in remotely and enter the user name and password of sybase

Enter a password using a password

Make sure to save

4: log in to query Analyzer with sa identity

The sybase data can be found by executing the following sql statement

Select * from linked server name (sybase in this example) .database name of Sybase .dbo.table name of Sybase

Note: if you find this problem when executing the query: the OLE DB provider "MSDASQL" of the linked server "sybase" provides inconsistent metadata for the column.

Solution: do not directly use the following statement

Select * from sybase.dbname.dbo.tablename

You just need to change the sentence and you can solve the problem. The specific statements are as follows:

Select * from openquery (sybase,'select * from dbname.dbo.tablename')

This is the answer to the question about how to access the table in Sybase in SQL Server. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.