Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2555
  • Last Modified:

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.
0
LeanMoreTryMore
Asked:
LeanMoreTryMore
  • 2
2 Solutions
 
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
 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now