Last post Jun 10, 2015 02:43 AM by wmec
Jun 07, 2015 09:07 PM|Harry US11|LINK
We have a ASP.net web application deployed on windows server 2003 - 32 BIT with IIS 6 and oracle DB 10g. Its working very fine with providerName="System.Data.OracleClient" in connection string.
But now its being migrated to windows server 2012 - 64 BIT with IIS 8.5 and oracle DB. I have installed oracle 11g client on the server and deployed the application. I want to use System.Data.Odbc OR System.Data.Oledb as providerName in the connection string
as 'OracleClient' being very old and is not sported.
But facing issues while connecting to database. Using these drivers gives me error 'invalid SQL statement' or doesn't connect at all to database.
OLEDB connects and then kills IIS process and i don't know why.
Could you please help here!!! with suggestions and preferred configuration.
Jun 08, 2015 04:44 PM|Lannie|LINK
When you installed the Oracle Client, did you install the Oracle Data Access component with Client Install?
Jun 10, 2015 02:43 AM|wmec|LINK
Try to check if you can run the same statement on Sql*Plus instead.