Try Now
More in this section

Forums / General Discussions / Error connect to Oracle when creating new project

Error connect to Oracle when creating new project

1 posts, 0 answered
  1. xman
    xman avatar
    4 posts
    07 Mar 2016
    07 Oct
    Link to this post

    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 http://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?



1 posts, 0 answered