• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to retrieve data from postgresql using odbc driver

 
Dinuka Arsakularatne
Ranch Hand
Posts: 198
  • 0
  • 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?
 
Scott Johnson
Ranch Hand
Posts: 518
  • 0
  • 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
  • 0
  • 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
  • 0
  • 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