I am importing data from SQL server to MsAccess via query

Insert INTO labels (linkage_index,label_name_index,label_value_index,label_line_number,extended_label)

select linkage_index,label_name_index,label_value_index,label_line_number,extended_label
FROM [ODBC;Description=Test;DRIVER=SQL Server;SERVER=Del91077\\ing;Database=SPR;User Id=SPR;Password=SPR].labels

its Working fine on developers m/c but failing on Clients machine which is also Win7.I have checked ODBC Drivers And SQL server is available there but still failing.Please help.

StackTrace: at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()

  • 1
    What is the actual error message? Not just the Stack Trace? Also, can you connect to both databases from the clients machine (i.e. Does it have access)? – Belogix Apr 2 '13 at 10:48
  • Is the Jet engine installed on the clients machine? – Neil Knight Apr 2 '13 at 10:48
  • Do client has SQL server client installed? There can be connection string problem as well, – Faisal Hafeez Apr 2 '13 at 10:49
  • Make sure you can connect to the SQL Server from other computers. By default, it's off. You need to enable it in the sql server's settings. – nvoigt Apr 2 '13 at 10:49
  • i am able to connect to the SQL Server from both computers – user2235712 Apr 2 '13 at 11:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy