This week's book giveaway is in the Cloud/Virtualizaton forum.
We're giving away four copies of Mesos in Action and have Roger Ignazio on-line!
See this thread for details.
Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC:ODBC Oracle Connection

 
Frank Daly
Ranch Hand
Posts: 148
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I've set up my DSN, named foobar, for my Oracle database. In the Server text box I put the ip address of the server. I now want to connect to it using JDBC:ODBC.
I'm using the following code.

Could someone point out how I connect please?
Frank
[ Edited to format code and fix ]
[ January 31, 2002: Message edited by: David O'Meara ]
 
Frank Daly
Ranch Hand
Posts: 148
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I should point out the error I got.
It reads [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified

Frank
 
Frank Daly
Ranch Hand
Posts: 148
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please ignore the previous posts. I've just read that the JDBC-ODBC bridge driver is dangerous.
I'll try and connnect using an Oracle JDBC driver. Any preferences?
Frank
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Frank Daly:
Please ignore the previous posts. I've just read that the JDBC-ODBC bridge driver is dangerous.
I'll try and connnect using an Oracle JDBC driver. Any preferences?
Frank

I'd use the Oracle Type-4 (thin) driver by preferance.
Dave.
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Frank Daly:
Please ignore the previous posts. I've just read that the JDBC-ODBC bridge driver is dangerous.
I'll try and connnect using an Oracle JDBC driver. Any preferences?
Frank

That description of the jdbc dbc bridge is a little harsh! Too often people try to get fancy, and expect the driver to be fully jdbc compliant! As long as you keep it simple, you shouldn't have any coding problems. Most of the descrepancies come at the hands of MS Access and the bridge or client configuration problems/overhead.
I would also recommend the thin(classes12.zip) drivers for Oracle.
Jamie
 
Frank Daly
Ranch Hand
Posts: 148
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks guys
Frank
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic