ODBC Error, Setting up Profile to Oracle DB

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?

Comments

  • 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.
  • edited February 2012
    Hi Steve,

    No luck. Ran through that and still got the same error.....
  • 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?
  • 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.
Sign In or Register to comment.