Page 1 of 1

ODBC Entry To Use?

PostPosted: Wed May 21, 2008 3:33 pm
by Kwakubah
I'm a postgreSQL newbie and I'm trying to convert my PT2 database from Access to postgreSQL in order to import it to PT3. It's asking me for 'ODBC Entry To Use' in the postgreSQL Settings and I have no idea what to put in here. Anyone know?

Re: ODBC Entry To Use?

PostPosted: Wed May 21, 2008 5:01 pm
by WhiteRider
I'm going to move this to the PT2 forum, where you'll get a better response, but this might help..
It is possible to use PT2 with postgres 8.3

Re: ODBC Entry To Use?

PostPosted: Wed May 21, 2008 5:05 pm
by ptrack pat
I would suggest uninstalling PT3 and PostgeSQL using the Start > Settings > Control Panel > Add or Remove Programs window.

Then delete the remnants of the c:\program files\postgesql\8.3 folder.

Download this version of PostgreSQL:
http://wwwmaster.postgresql.org/downloa ... .3.1-1.zip

Extract all the files out of the ZIP file into a separate folder.
Then double-click on the postgresql-8.3.msi file to install it.

The last part of the install is the Stack Builder application you can run. See here for what to select...
archives/PT2/viewtopic.php?t=24880

Then on the PostgreSQL Settings window in PT2, you would select "PostgreSQL Unicode" from the list.

Later, you can reinstall PT3 but when you do, you just need to do the install that doesn't include PostgreSQL because it's already installed.