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

mysql - FireDac error 314 - but DLLs are in program directory -

git - How to list all releases of public repository with GitHub API V3 -

c++ - Getting C2512 "no default constructor" for `ClassA` error on the first parentheses of constructor for `ClassB`? -