locked
The underlying provider failed on Open. RRS feed

  • Question

  • Hi
    i create a simple application in my visual studio 2010 beta 2 with entity framework which get data from Order_Details table and display it in dataGridView, but when i bind orderDetailsBindingSource to my objectQuery, i got this error :

    The underlying provider failed on Open.
    i connect to another machine which have sql server 2005 with sql authentication via its ip. i can connect to my sql server instance and load all tables and ... in server explorer, but i don't know why i got this error in my app at runTime.
    thanks in advance
    this is my Signature
    Saturday, October 31, 2009 4:12 PM

Answers

  • Hi Ido Flatow
    i recreate the project and my problem has been solved. i think it might be for connectionString, because it has userID but desn't have password (i connect to database with Sql Authentication)
    thanks for reply.
    this is my Signature
    • Marked as answer by Hamed_1983 Saturday, October 31, 2009 5:19 PM
    Saturday, October 31, 2009 5:19 PM

All replies

  • Can be all sorts of problem, perhaps even a security issue. Can you paste the entire exception information? including stack trace?
    Please mark posts as answers/helpful if it answers your question
    Saturday, October 31, 2009 5:10 PM
  • Hi Ido Flatow
    i recreate the project and my problem has been solved. i think it might be for connectionString, because it has userID but desn't have password (i connect to database with Sql Authentication)
    thanks for reply.
    this is my Signature
    • Marked as answer by Hamed_1983 Saturday, October 31, 2009 5:19 PM
    Saturday, October 31, 2009 5:19 PM