Distribuited query

• lele

  Newbie

  Points: 1

  More actions

  May 14, 2003 at 2:34 am

  #82180

  I have to get data (via openrowset) from an Access database that is located on another one server (and another domain).

  I've tried to map the Access partition on my Sql Server but i have no privileges to run the query...

  Is there someone that have an idea?

  Thanks

  leledimilano

  
  leledimilano

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  May 14, 2003 at 3:29 am

  #457074

  SQL must have permissions to the access db and be able to access it.

  Create a DSN (e.g. TEST) on the server to point to the access database.

  Use

  select * from OPENROWSET('MSDASQL','TEST';'admin';'','select * from Table1')

  or without a DSN use

  select * from OPENROWSET('MSDASQL','Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\somepath\mydb.mdb;Uid=admin;Pwd=','select * from Table1')

  Edited by - davidburrows on 05/14/2003 03:40:36 AM

  Far away is close at hand in the images of elsewhere.
  Anon.