Issues with different versions of Oracle.DataAccess.dll
546971Apr 11 2011 — edited Apr 12 2011I have a .net web service application which references version 10.2.0.100 of Oracle.DataAccess.dll. A client has setup Oracle 10g database on the server, but I think the server has a patch set installed so it appears that the versions of Oracle.DataAccess.dll in my web service and on the database server do not match. When I issue a query via the web service on my local machine using my oracle 10g client, the web method returns the correct data. If I issue the same query using the same .net web service on the clients database server, I get the following error: Oracle.DataAccess.Client.OracleException: ORA-00923: FROM keyword not found where expected. There's nothing wrong with the query syntax, I can run the same query from SQL Plus on the database server and get the correct data. Could it be a compatibility issue between the Oracle.DataAccess.dll referenced in my web service application and the file on the sever. I'm not sure what else to look for, any advice is greatly appreciate, and I can answer any questions if needed.
Thanks,
NA