SQL Server 2008 connects to Sybase ASE with ODBC

1: Requirements: Install Sybase client software and SQL Server Software on PC

(I am installing the Sybase ASE 12.5.1 client software and SQL Server 2008 software on my Test PC.) )

2. Configure the ODBC data source for Windows:

Start menu-Control Panel (c)-Administrative Tools-Data source (ODBC)-"Enter the configuration User DSN or System DSN can: Add-" Select Sybase ASE ODBC driver-Custom Data source name (arbitrary as: Sybase)-"Database name (required!) such as Db_test)-"determined to complete."

--Here is the schematic process----------------------------------

-"Start Menu-" Control Panel (c)

-"Management Tools"

-"Data source (ODBC)

-"Enter the configuration user DSN or the System DSN can be (I am testing the System DSN is configured)

-"Add-" select Sybase ASE ODBC Driver

-"Custom data source name (optional: Sybase)

-Database name (required!) such as Db_test)-"determined to complete."

Or, in order to test whether it was successful, in the previous step of OK,

-"Press test connect-" Enter login ID and password-"OK

. If successful, you will be prompted to pop the window.

---to this configuration and test ODBC completion!---------------------------------

3. Configure the connection server in SQL Server 2008:
Enterprise Manager-"Security-" Connect Server-"Right-click New Connection Server-" define the connection name;

Select other data sources;

Specifies the program name: Microsoft OLE DB Provider for ODBC Drivers;

Product name is optional;

The data source specifies the name of the data source that was defined in ODBC just now;

Access interface string, location, directory can not be filled.

-"Security tab": Set the database user name and password for Sybase in this security context

-The "Server Options tab" is available by default

-"OK."

----The following is a schematic procedure--------------------------------------------------------------------

Enterprise Manager-"Security-" Connect Server-"Right-click New Connection Server-" define the connection name;

P.S: When you log in to SSMs, it's best to use SA users.

Specifies the program name: Microsoft OLE DB Provider for ODBC Drivers;

Product name is optional;

The data source specifies the name of the data source that was defined in ODBC just now;

Access interface string, location, directory can not be filled.

-"Security tab": Set the database user name and password for Sybase in this security context

--Test whether the connection was successful

1.

2.

----to this configure SQL Server 2008 Connection server end---------------------------------------------

4. Testing

All preparations are complete! In SQL Server Enterprise Manager-"security-" The connection server opens the newly built connection server-click on the table, you can see in the right window all the table names that the Sybase database user has, but it is not possible to view the table records here, this need in the SQL Query Analyzer for server is implemented with specific SQL! If you do not see the table, refresh the linked server, you can see.

When accessing a table, use the format: [Connect server name] ... [Sybase user]. [Table name].

More detailed specific use here no longer repeat.

Prepare the data before testing, create a new table test1 in Sybase, insert a few data, and query the results as follows

Then query the data in SSMs, and the query results are as follows. The connection is successful!

Article Source:SQL Server 2008 connects to Sybase ASE with ODBC

SQL Server 2008 connects to Sybase ASE with ODBC