Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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()

share|improve this question

migrated from Apr 3 '13 at 8:02

This question came from our site for professional and enthusiast programmers.

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 posting your answer, you agree to the privacy policy and terms of service.