Hi
I have an application where it uses SQL SERVER as backend, now i want to migrate to form SQL SERVER to ORACLE. I have made changes to configuration file to connect Remote ORACLE database, but at the time of execution it throws an exception that "Oracle client is not installed". Cant we cannot to ORACLE without client installtion on the machine.If YES, please help me how can we do that. Or should i make any changes to the Configuration file to make it work.
Below is the Configuration file: This code is inside WEB.CONFIG file <nhibernate> <add key="hibernate.dialect" value="NHibernate.Dialect.OracleDialect"/> <add key="hibernate.connection.driver_class" value="NHibernate.Driver.OracleClientDriver"/> <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/> <add key="hibernate.connection.connection_string" value="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.113)(PORT=1521))(CONNECĀT_DATA=(SERVICE_NAME=orcl)));User Id=tempUSR;Password=tempPWD)"/> </nhibernate>
Thanks, Shiva kumar.
|