Newbie - SQL connection to Sybase

[Nozy]

Greetings all

Need some help or a pointer in the right direction, since not being a DB expert.

Working on a project, where an application needs to connect to a database. The easy part is it can be done very easly, only problem is that it will only use MS SQL. Requirements are that it should connect to Sybase ver12. I have two questions ??.

1 - If I use MS SQL server with the application as a middle ware, Is it possible for me to connect to Sybase.

Application <---> MS SQL <---> Sybase

Also how would I be able to keep the two in syc (tables) with each other.

2 - (Stupid question) is there an ODBC driver that would enable me to connect stright from the application to sybase (middleware).

Cheers
All

 

[JJayUK]

Your first question: This seems needlessly complicated and I don't think SQL Server could manage it anyway.

Second: Yes. Sybase provide Windows compatible ODBC software which allows you to connect straight to Sybase using ODBC. I've been using it for years.

If you have the Sybase install disks you may find software for Windows on there. If not check out the Sybase website or contact your Sybase support person (if you have one).

Regards,
JJayUK

 

[Nozy]

Hello

Is it possilbe for SQL to share same tables as Sybase.

Cheers

 

[tlbroadbent]

You can link the Sybase Server into SQL Server. SQL BOL has details about linked servers.

Configuring Linked Servers

http://msdn.microsoft.com/library/en-us/adminsql/ad_1_server_4uuq.asp

sp_addlinkedserver

http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_adda_8gqa.asp

You can update Sysbase tables from SQL Server using the linked server. You can use distributed transactions where updates take place on both servers in the same transaction or you can replicate data provided you use a compatible OLE DB provider or ODBC driver. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[Nozy]

Cheers

It was just the answer that I was looking for.

NOZY