none
Error message - The underlying provider failed on Open. RRS feed

  • Question

  • I have a Web service that accesses records via entity framework.  I am able to call the web service and read records in debug mode, but I have uploaded the web service to a test site and I am unable to access any tables.  I have checked all of my configuration strings, we compared the URL settings from a URL that is working, but have not been able to find the source of the issue.  Does anyone have any suggestions of other areas to check.  The error message that we are gettings is "The underlying provider failed on Open".  We are not doing an explicit Open, but this is working fine in debug.
    Wednesday, June 17, 2009 10:53 PM

All replies

  • I have exactly the same problem did you ever resolve this?
    Wednesday, February 3, 2010 12:34 AM
  • It looks like the problem is associated with account privileges in the production environment. Refer to http://th2tran.blogspot.com/2009/06/underlying-provider-failed-on-open.html .
    Devart Team
    http://www.devart.com/dotconnect
    ADO.NET data providers for Oracle, MySQL, PostgreSQL, SQLite with Entity Framework and LINQ to SQL support
    Thursday, February 4, 2010 2:05 PM
  • Hi Thanks for the reply.

    I gathered this was a permission issue as I could correctly connect to the service and spit out Domain\user via properties, in the Environment classs, using Debug.Write. After this point I was getting the "The underlying provider failed on Open " error. The interesting part was my user had access to the db to make the connection. Now I only had to do this for a prototype so just added the username and password to the connection string and it worked.

    However my research lead me to believe that the answer lies in Delegation http://msdn.microsoft.com/en-us/library/ms730088.aspx (last paragraph of article) I could connect and use the service under "user x" but the service did not have permission to delegate calls on behalf of this user. Thats what I think anyway ;o)
    Monday, February 8, 2010 1:38 AM