ODBC Error, Setting up Profile to Oracle DB
  • Darkvette February 8

    Hello,

    I am running ES 2.92.11 on a Windows Server 2008 R2 64-bit Server.

    Our database is Oracle, and I do have the Oracle 11g R2 32-bit client installed on the box as well.

    32-bit ODBC is configured properly and ES can communicate with the Oracle DB just fine.

    When I went to setup the Web Reports, I got everything setup properly, then upon going to setup the connection to the Oracle Database, I get the below error.

    Attempt Failed. Error -2147467259
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    Here is my ODBC connection String (same one used in the ES Database Connection):

    Dsn=esprd;server=ESPRD.myserver.COM;uid=eventsentry_web;pwd=

    Everything else works just fine, except this. I'm at an impass, and need help to get this working.

    Thoughts?

  • Steve February 8

    Hi Darkvette,

    It sounds like you may not be running IIS in 32-bit mode.

    Please reference the following URL: http://www.eventsentry.com/kb/122

    This should help you set IIS up in 32-bit mode which should resolve this issue.

  • Darkvette February 9

    Hi Steve,

    No luck. Ran through that and still got the same error.....

  • Steve February 9

    Are you able to setup a 32-bit DSN using:
    'C:\WINDOWS\SysWow64\odbcad32.exe'?

    If so, do you get any errors if you use that DSN in your web reports?

  • Darkvette February 9

    The issue was with the ODBC Connection string that I was using in the Profile Setup for the Web Reports. I found the following link, http://connectionstrings.com/oracle#p21

    Using this type of DSN worked, and am now able to use Web Reports.

    Thx for your help.

Add a Comment

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In

Categories