Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 stackoverflow.com Apr 3 '13 at 8:02

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

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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.