Link to home
Start Free TrialLog in
Avatar of LeanMoreTryMore
LeanMoreTryMore

asked on

Jasper datasource - Can't create dabase JDBC connection via Connections properties

I have installed Jasper and created the datasource via Connection properties

JDBC Driver: sun.jdbc.odbc.jdbcOdbcDriver
JDBC URL:jdbc:sun:oracle://123.125.90.107:1521;sid=dev

username:username
password:mypassword

When i click on the test button, it displays the following error message

General problem:null
Please check your username and password. The DBMS is running

Notes. the database is up and running and both user and password are correct.

In the Classpath, I add the Sun driver dt.jar

eg. c:\j2sdk1.4.2_08\lib\dt.jar

is dt.jar a Sun driver?

Please help
I'm sure you java guru know about these.
thanks.
Avatar of Mick Barry
Mick Barry
Flag of Australia image

that connect string looks wrong, try:

jdbc:odbc:dsn

where dsn is your data source name
Avatar of LeanMoreTryMore
LeanMoreTryMore

ASKER

OK . i changed the connection string to jdbc:sun:oracle://123.125.90.107:1521;SID=gdev

This connection string works for my netbean tools.

But i got the same problem.

SOLUTION
Avatar of Mick Barry
Mick Barry
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial