The underlying provider failed on Open.

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

Answer 1

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

Answer 2

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