OpenRowSet/GetDataSource

• fric_frac

  Valued Member

  Points: 58

  More actions

  April 28, 2003 at 8:31 pm

  #158880

  I'm having a problem with OPENROWSET and GETDATASOURCE. These appear to be excellent tools but I cannot get them to work with a UNC. They'll work as long as the Access database is on the same server as SQL 2000 but I get a file is open exclusively or you don't have permission error when trying to connect to a remote server. I get the same error when trying to connect via LinkedServer through Enterprise Manager. Any ideas?

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  April 29, 2003 at 5:35 am

  #455646

  I've used it, so I know it's possible. Are you absolutely sure you do have permissions to access the file on the UNC path?

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter