• 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:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

how to retrieve data from postgresql using odbc driver

 
Ranch Hand
Posts: 198
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi all,
can some one please tell me how to connect to postgresql database using the odbc driver for postgre? i have already downloaded the driver but have problems connecting to using a datasource... can someone please let me know how i can connect to postgre sql?
 
Ranch Hand
Posts: 518
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

tell me how to connect to postgresql database using the odbc driver



Why would you want to use an ODBC driver? Do you mean JDBC driver?


have problems connecting to using a datasource



For us to help, we'll need more information about your problem. What is the Exception? Error message? Stacktrace? Also, post the section of your code where you encounter the problem.
 
Dinuka Arsakularatne
Ranch Hand
Posts: 198
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
well im relatively new to jdbc and do not know exactly how to use it... i know a bit about odbc and was able to connect ms access using odbc. so i thought ill use odbc to connect to postgre as well but found out that its a completely different scenario because you cant specify a location directly to the database as in access... can you please help me in this matter? an example of what i need and how to connect to postgre database?

thank you in advance
 
Dinuka Arsakularatne
Ranch Hand
Posts: 198
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
problem solved. sorry if i disturbed any of you guys.. i learnt the hard way of trial and error... im happy
 
After some pecan pie, you might want to cleanse your palatte with this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic