Book a Demo

Author Topic: Error in connecting to Oracle 9i Database  (Read 1975 times)

jfuhring

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
  • Create useful diagrams
    • View Profile
Error in connecting to Oracle 9i Database
« on: February 09, 2006, 10:44:54 am »
I'm attempting to perform a data transfer of an .EAP file to an Oracle 9i database. The proper SQL script has been run and I've tested the connection using SQL net.

When I attempt to setup the target model, I choose the "Oracle Provider for OLE DB"; enter in the proper service name, user id, and password; and successfully test the connection. However, when I select "OK", I receive the error..."Login Failed. Catalog information cannot be retrieved". What causes this error?

I tried this setup with MDAC 2.7 and updated to 2.8 sp 1. Still have the problem.