Error connect to Oracle when creating new project

Posted by Community Admin on 03-Aug-2018 08:57

Error connect to Oracle when creating new project

All Replies

Posted by Community Admin on 07-Oct-2016 00:00

Hi everyone,

I get error when creating SF project connect to oracle db.

My environment:
    1) I have SF run on IIS 7.7 (Win 7 64bit)
        I Follow docs.sitefinity.com/configure-the-iis-to-host-sitefinity-projects to prepare the IIS
        I created SF project using SF Project manager and attached it as virtual application within IIS Default Website
        I have installed ODAC ver 12 32bit for windows (i have tried the 64bit)
        I set the TNS (i can connect with other app e.g. 'Toad For Oracle' from this machine)
    2) Oracle XE 11g
        I create user for sitefinity and grant several related priviledge

So, when creating project, i get and error ORA-22062 (in err2.png),
I switched the ODAC version with 64bit but still not work,
I also tried switcing the IIS  on Application Pools/DefaultAppPool/Advance Setting, then switch the "Enable the 32 bit Applications=true" , but still not work(in err1.png).

I don't have any idea to resolve it, can someone give me clue whats missing?

Regards,

Eddy

This thread is closed