sql x sysbase

8 Jun 2006 12:25 AM

Frank Dulk

would like to know if I get to do some view tying a table SQL with sybase
for the query analiser, I have a program that the database this in Sybase
and other in SQL and I need to tie those tables.

8 Jun 2006 2:13 AM

Stu

Hey Frank,

Look up linked servers and OPENQUERY in the SQL Server Books Online.
Should get you going.

Stu

Frank Dulk wrote:
Show quote

> would like to know if I get to do some view tying a table SQL with sybase
> for the query analiser, I have a program that the database this in Sybase
> and other in SQL and I need to tie those tables.

10 Jun 2006 3:23 PM

Derekman

Frank,
Sybase is not the easiest database engine to create a linked server or
connect to. Sybase has a free download of their SQL Anywhere Developers
studio which provides native support for Sybase connections. After
installation there are even native .NET integration for IAnywhere
dataobjects.

Back to SQL, if you download and install the SQL Anywhere Developers
studio you will have local Sybase file DSN's to create a connection for a
linked server. I tried working with OLEDD connection without any luck until
I installed and used the Sybase DSN.
Try the below link and search for SQL Anywhere and clik the download
hyperlink on the right side of the screen.
http://search.sybase.com/search/simple.do
Good Luck

Show quote

"Frank Dulk" wrote:

> would like to know if I get to do some view tying a table SQL with sybase
> for the query analiser, I have a program that the database this in Sybase
> and other in SQL and I need to tie those tables.
>
>
>