Last post Nov 23, 2010 02:25 AM by Wencui Qian - MSFT
Nov 18, 2010 11:03 AM|Frances_zxw|LINK
I recently installed the latest Oracle Data Provider for .NET(ODP.NET 22.214.171.124.2), due to the fact that Microsoft Oracle Client is deprecated. Ever since the new installation, my SqlDataSource control stopped working. When I try to configure the data source
of the SqlDataSource and test the connection, it always gives me the following error message:
Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online.
OCIEnvCreate failed with return code -1 but error message text was not available. at DataObjectSupport(721,6)
I know for sure the connection settings are definitely correct and the database is online for sure, because any databinding I did manually works perfectly well. I can manually bind to a Gridview, ListBox controls and display the data without any problem. The only
problem I have is using the SqlDataSource. This is painful because Gridview and Listview have a lot of cool built-in features. When you databind the controls in the code behind file, you lose all the features.
I have added ASPNET to the Oracle home directory and granted it full control access and retarted the computer but it doesn't work. I'm using Visual Studio 2010 and the database is Oracle 10g. Does anybody know why I'm having problem with SqlDataSource only?
Nov 23, 2010 02:25 AM|Wencui Qian - MSFT|LINK
I recommend you to report this problem to Microsoft on Connect site and see whether they can repro and help to resolve this problem: