aspose file tools*
The moose likes JDBC and the fly likes how to retrieve data from postgresql using odbc driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to retrieve data from postgresql using odbc driver" Watch "how to retrieve data from postgresql using odbc driver" New topic
Author

how to retrieve data from postgresql using odbc driver

Dinuka Arsakularatne
Ranch Hand

Joined: Aug 12, 2006
Posts: 198
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?


if who i am is what i have, and what i have is lost, then who am i?<br /> <br />SCJP 5.0<br />SCWCD 1.4<br />SCBCD preparing
Scott Johnson
Ranch Hand

Joined: Aug 24, 2005
Posts: 518
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

Joined: Aug 12, 2006
Posts: 198
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

Joined: Aug 12, 2006
Posts: 198
problem solved. sorry if i disturbed any of you guys.. i learnt the hard way of trial and error... im happy
 
 
subject: how to retrieve data from postgresql using odbc driver