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.
LeanMoreTryMoreAsked:
Who is Participating?
 
Mayank SAssociate Director - Product EngineeringCommented:
>> i changed the connection string to jdbc:sun:oracle

No, try with jdbc:odbc:DSN_NAME is what objects meant. You'll need to create an ODBC data-source using:

http://recursivetechnology.com/documentation/ODBC_Creation_Guide.htm
0
 
objectsCommented:
that connect string looks wrong, try:

jdbc:odbc:dsn

where dsn is your data source name
0
 
LeanMoreTryMoreAuthor Commented:
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.

0
 
objectsCommented:
Is the odbc data source defined?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.