Post reply

Remote query

  • February 10, 2009 at 2:10 am

    #72427

    server 1 - I have created one view with username and password

    so, i want access server 1 view to server 2, pls tell me how do create the query in server 2?

    thanks

  • February 10, 2009 at 2:25 am

    #941023

    i have tried, but not hope

    SELECT a.*

    FROM OPENROWSET('MSSQL OLE DB',

    'DRIVER={SQL Server};SERVER=10.4.51.55;UID=energymeter;PWD=readhouse',

    rais.dbo.energy_meter_house) AS a

    ORDER BY a.emp_no, a.empname

    plz tell me what is the problem?

    thanks

  • February 10, 2009 at 2:56 am

    #941037

    You can try using the SQLOLEDB provider....

    SELECT a.*

    FROM OPENROWSET('SQLOLEDB.1',

    'SERVER=10.4.51.55;UID=energymeter;PWD=readhouse',

    'SELECT * FROM rais.dbo.energy_meter_house') AS a

    ORDER BY a.emp_no, a.empname

    --Ramesh

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

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