• 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Jeanne Boyarsky
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
Sheriffs:
  • Paul Clapham
  • Junilu Lacar
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Ganesh Patekar
  • Tim Moores
  • Pete Letkeman
  • Stephan van Hulst
Bartenders:
  • Carey Brown
  • Tim Holloway
  • Joe Ess

how to retrieve data from postgresql using odbc driver  RSS feed

 
Ranch Hand
Posts: 198
  • Mark post as helpful
  • send pies
  • 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
  • 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
  • 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
  • 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
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!