Win a copy of Head First Android this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Rob Spoor
  • Bear Bibeault
Saloon Keepers:
  • Jesse Silverman
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Al Hobbs
  • salvin francis

jdbc odbc bridge

 
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi everybody,
Samll doubt. Is it possible to connect to remote server with out having client installed on local machine using jdbc dbc bridge ?
Thank you,
bye,
vamsi.
 
Author
Posts: 93
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by vamsi bezawada:
Hi everybody,
Samll doubt. Is it possible to connect to remote server with out having client installed on local machine using jdbc dbc bridge ?
Thank you,
bye,
vamsi.



Hi Vamsi,
No. If you are going to use the JDBC-ODBC bridge you need to have the database middleware and ODBC driver installed on the client. For instance, if I am using Oracle, the Oracle JDBC driver and the JDBC-ODBC driver, I would need to have the following software installed and configured:
1. Oracle ODBC Driver installed and configured
2. SQL*NET with a valid tns-names.ora file
3. The jdbc-odbc drivers installed.
Hope that helps.
Thanks,
John Carnell
 
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Sun says this It doesn't matter if you do or don't have the driver locally because the odbc bridge doesn't ensure remote access to databases. Most databases have a free driver available that supports remote access to the specific database( other than ODBC). Which database are you using?
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic