ODBC Connection String

[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

[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).

[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.

[doco]

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

[kraada]

It's ok, we all have those days sometimes