Page 1 of 1

ODBC Connection String

PostPosted: Tue Nov 10, 2009 2:25 am
by doco
I am attempting to access my poker hands database using a query editor. No connection string I found on the internet google search is working.

Code: Select all
Driver={PostgreSQL};Server=IP address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword;


Is an example. I have also created a DSN that tests successful but connect string using DSN will not connect either

Is there a standard? - Ideas?

TIA

Re: ODBC Connection String

PostPosted: Tue Nov 10, 2009 9:21 am
by kraada
Is there a reason you aren't using PGAdmin which comes with the PosgreSQL package? If you want a graphical manner of creating queries, that will do it for you (it's on your start menu under PostgreSQL 8.3).

Re: ODBC Connection String

PostPosted: Tue Nov 10, 2009 10:57 am
by doco
I only just downloaded PT3 demo yesterday, I will not purchase until next month - budgets ARGH!. So, I am not familiar with the QBE added to PT3 - I am sure I will become intimate with it eventually though. Having said that, there is no better way to become familiar with ones data than writing script. ;-)

Re: ODBC Connection String

PostPosted: Tue Nov 10, 2009 11:06 am
by doco
kraada wrote:Is there a reason you aren't using PGAdmin which comes with the PosgreSQL package? If you want a graphical manner of creating queries, that will do it for you (it's on your start menu under PostgreSQL 8.3).


OK, I have now had my morning coffee and re-read the post. It is a wonderful suggestion and has a query editor as well - thanks :oops:

Re: ODBC Connection String

PostPosted: Tue Nov 10, 2009 11:20 am
by kraada
It's ok, we all have those days sometimes :)

highfalutin