Forum Stats

  • 3,852,528 Users
  • 2,264,112 Discussions
  • 7,905,094 Comments

Discussions

JDBC for Ms SQL 7.0

Hi,
We are trying use Oracle BI EE to report of a Ms SQL server v7.0 database.

When I try to connect to the database using the JDBC connection in the Admin section, I get a "Could not establish connection" error.

Is there a specific driver that would allow this connection to work?

Also I am using my Windows user name and password to connect to the database on the network, i do not have a separate MS SQL server account.(Could this be the problem?)

Any suggestions would be appreciated.

Thanks,
Anisha

Answers

  • 660750
    660750 Member Posts: 19
    AS a potential solution to this problem, we downloaded a generic JDBC driver for SQL server 7.
    Also to connect to the sql server source db, a DB user was created which did not rely on windows authentication.

    -A
This discussion has been closed.