how to retrieve data from postgresql using odbc driver
Dinuka Arsakularatne
Ranch Hand
Joined: Aug 12, 2006
Posts: 198
posted
0
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
posted
0
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
posted
0
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
posted
0
problem solved. sorry if i disturbed any of you guys.. i learnt the hard way of trial and error... im happy
0
