Microsoft.ACE.OLEDB.12.0 error with query

• danschl

  SSCertifiable

  Points: 5770

  More actions

  October 24, 2013 at 2:03 pm

  #281701

  Logged in to server_a

  SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

  'Excel 8.0;Database=\\server_a\backuptp\server_times.xls',

  'SELECT * FROM [log_report$]');

  SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

  'Excel 8.0;Database=\\server_b\backuptp\server_times.xls',

  'SELECT * FROM [log_report$]');

  SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

  'Excel 8.0;Database=\etworkdrive\backuptp\server_times.xls',

  'SELECT * FROM [log_report$]');

  SERVER_A 10.50.4000 these work for everything and all accounts

  SERVER_B 10.50.4000

  Installing on Server B everything works on service account but not my account on Server B

  this works on my desktop logged in as me connected to server_b in ssms

  SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

  'Excel 8.0;Database=\\server_b\backuptp\server_times.xls',

  'SELECT * FROM [log_report$]');

  this doesnt work on my desktop

  SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

  'Excel 8.0;Database=etworkdrive\backuptp\server_times.xls',

  'SELECT * FROM [log_report$]');

  not sure how it would work on my desktop connected to server_b

  but not logged into server_b using my login name

• danschl

  SSCertifiable

  Points: 5770

  More actions

  October 25, 2013 at 7:45 am

  #1661626

  i fixed myself the new machines did not have the

  c:\users\temp directory

  got to love microsoft