In this article we going to look into creating a heterogeneous linked server. i.e. We are going to create a linked server to SYBASE database server from SQL Server environment and then going to query data’s from Sybase. First step in heterogeneous linked server is to create a ODBC connection to that RDBMS platform. For creating ODBC connection we need the ODBC drivers for that RDBMS platform. In this case we need Sybase driver in client machine, this is not included in windows so you need to download it from Sybase Website. Lets discuss on this step by step
Category Archives: General - Page 4
Creating Linked server to SYBASE from SQL Server
Posted by Vidhya Sagar
on December 5, 2009
No comments
Configuring Data Compression – SQL Server 2008 – Part 4
Posted by Vidhya Sagar
on November 28, 2009
No comments
SQL Server 2008 R2 November CTP Released
Posted by Vidhya Sagar
on November 10, 2009
3 comments
SQL-Articles Website Replenished with New Look
Posted by Vidhya Sagar
on November 8, 2009
No comments
I’m happy to announce you that today we have upgraded our main website to Content management system. Now we have more flexibility on posting articles. Some of the key features on new design
SQL Server 2008 MCITP (70-453) Exam
Posted by Vidhya Sagar
on October 30, 2009
9 comments
Today I’ve written the exam 70-453 (Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008) and I’ve cleared the exam. I would like to share the information regarding this exam. While preparation I’ve searched for these information but I got very limited information on this, so I think this could be helpful for you.