Problem
.net - can not connect to oracle server via my web hosting..
Impact
Can't fetch any data from the server and on the webpage it shows an error.
Solution
oracle support was deprecated by the Microsoft.
so what we use on our local machine is the oracle support for the .net
as it is the third party add-on so no hosting company provides oracle support as it may be unsafe.
so to have oracle support you must buy an dedicated server then your hosting company will do anything that you tell them to do and will install all your add-on.
but if you still want to use oracle on your shared hosting you can but you need to have permission to have trustlevel "full" over the server. and then if you have that you can upload dlls for oracle in to your bin folder and your web.config file should point to these dlls.
Working with these dlls will be quite tricky as there are 7 dlls that you need to upload on the server and still it doesn't support some functionality like ADDWITHVALUE function for parameters.
and you will face some problem while working with int parameter.
but the way is to use for that is don't use parameters and build a query using sting and it is really unsafe to and easy to hack.
.net - can not connect to oracle server via my web hosting..
Impact
Can't fetch any data from the server and on the webpage it shows an error.
Solution
oracle support was deprecated by the Microsoft.
so what we use on our local machine is the oracle support for the .net
as it is the third party add-on so no hosting company provides oracle support as it may be unsafe.
so to have oracle support you must buy an dedicated server then your hosting company will do anything that you tell them to do and will install all your add-on.
but if you still want to use oracle on your shared hosting you can but you need to have permission to have trustlevel "full" over the server. and then if you have that you can upload dlls for oracle in to your bin folder and your web.config file should point to these dlls.
Working with these dlls will be quite tricky as there are 7 dlls that you need to upload on the server and still it doesn't support some functionality like ADDWITHVALUE function for parameters.
and you will face some problem while working with int parameter.
but the way is to use for that is don't use parameters and build a query using sting and it is really unsafe to and easy to hack.