SQL Power Business Intelligence Productivity Tools

SQL Power Software Forum

SQL Power Software Forum

  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page  [Register] Register /  [Login] Login 
Problem in Creating a new repository  XML
Forum Index » SQL Power DQguru Technical Support
Author Message
Ram Mohan T


Joined: 2009-10-26 03:29:04
Messages: 3
Offline

Hi All,
I am very new to DQGuru. My ultimate aim is to load a oracle table and do some cleansing on it. For this i am trying to create a connection.

I am getting the following error when i am trying to Test the connection.

"java.sql.SQLException: Couldn't connect to database "Ram_Test":
JDBC Driver org.postgresql.Driver
does not accept the URL jdbc:oracle:thin:@172.24.252.7:1521:orcl"

The values i have given are:
Con Name - Ram_Test
db type - oracle 10g
jdbc url - jdbc:oracle:thin:@172.24.252.7:1521:orcl
uname - abc
pwd - abc
Repository Qualifier - NULL

I have downloaded the jar file and added it in the "JDBC Drivers" tab of DQGuru.

Please help me in resolving this.

Thanks in Advance,
Ram Mohan T
Benjamin


Joined: 2006-09-08 17:47:35
Messages: 163
Offline

Hi,

it seems like you are using the wrong connection settings to connect to Oracle, you are using a Postgres JDBC driver instead of an Oracle one:
JDBC Driver org.postgresql.Driver


Make sure you have the Oracle JDBC driver available on your computer, it is not included in the DQGuru download. You'll have to point to the Oracle driver in the JDBC settings of DQGuru.

Then you'll be able to create a connection to connect to Oracle.

Benjamin

--------------------------------------
Get involved: http://goo.gl/lt6r
--------------------------------------
[WWW]
Ram Mohan T


Joined: 2009-10-26 03:29:04
Messages: 3
Offline

Hi Benjamin,

Thanks a lot for your valuble inputs. Now its working fine...

Regards,
Ram Mohan T
 
Forum Index » SQL Power DQguru Technical Support
Go to:   
Powered by JForum 2.1.8 © JForum Team