Post reply

SQL Server Connection String to query SQL Server 2005 using SQL Server 2000

  • May 7, 2009 at 6:24 am

    #130687

    Hi Guys,

    Can someone please direct me, I am trying to query by connecting my table in SQL Server 2000 with the Table in SQL Server 2005 , both the tables have Windows Authentication.

    I am trying to use with OpenRowSet but if there is a better way then pls let me know.

    My Query:

    SELECT

    *

    FROM

    danilins.Table1 (SQL 2000) a INNER JOIN

    OPENROWSET('SQLOLEDB', 'DRIVER={SQL Server};SERVER=CSDGWEB;Integrated Security=SSPI;',

    EPP_Prod.EPP_Developer.Table2(SQL Server 2005) c ON a.MPAN = c.MPXN

    Any help will be greatly appreciated!

    Cheers,

    Arun

  • May 7, 2009 at 10:16 am

    #990482

    Not sure why you want to use OpenRowset(). I would think you would probably be better suited to create a linked server on your 2005 box to the 2000 server. Then you can write a query using the standard server.database.owner.table

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply