SharePoint Designer SqlDataSource "An unexpected error has occurred"
VronOct 15 2009 — edited Oct 19 2009Hi, gurus!
I am a long time Oracle developer just getting started with SharePoint Designer.
We have a development server on Windows 2008. and production Win 2003 servers on a SP farm. All have ODAC 11.1.0.6.21
Using SharePoint Designer on my local computer, I created a Dev Server site and page with a SqlDataSource and GridView that accesses an Oracle db on a different machine. Works great.
After creating the same site and page on a Prod Server, the testing works within SharePoint Designer, but after publishing the site, in IE it returns the dreaded 'Error An unexpected error has occurred'.
I cannot get ODP.NET to create a trace file after setting up the TraceLevel and other parameters in the registry. I also added Oracle.DadaAccess lines to web.config to no avail.
--
I created a VB app in Visual Studio to test the connection. When I run the application on the DEV or PROD boxes, it connects to the db, returns the expected value and creates the ODP.TRC file.
--
I carefully compared the files mention on http://splinter.com.au/blog/?p=156 and everything looks okay.
--
What should I try next?
Thank you so much for your help!