c# - Issues with viewing Oracle tables on local host and IIS -


i receiving 2 errors, depend on references using, think both relatively similar issues.

the first error reference:

using system.data.oracleclient; 

which causes error of:

attempt load oracle client libraries threw badimageformatexception.  problem occur when running in 64 bit mode 32 bit oracle client components installed. 

i understand reference depreciated, used oracle reference:

using oracle.dataaccess.client; 

but give me error of:

the type initializer 'oracle.dataaccess.client.oracleconnection' threw exception 

both of these references work oracle stored procedure on local host, throw these errors when run page in iis. on server have oracle 64-bit client installed, on actual computer have 32-bit client installed.

my major question is: why oracle database connect server on local host, , execute stored procedure though have 32-bit client installed on machine , 64-bit client on server?

i have enabled 32-bit applications on application pool in iis, , did not correct issue. have tried copying 64-bit oracle .dll's project, did not work.

would installing 64-bit client on machine, , rebuilding project proper oracle .dll's solve problem? need regenerate connection string?

thanks

as posted luke woodward, changing oracle.dataaccess.client oracle.manageddataaccess.client, code runs charm. luke!


Comments

Popular posts from this blog

angular ui router - 10 digest iterations reached in angularjs when using $state.go -

symfony - InvalidConfigurationException in SecurityExtension.php line 429: No authentication listener registered for firewall "secured_area" -

javascript - Can Piwik report referrer in real time? -