Page 1 of 1

Database Error

PostPosted: Wed May 14, 2008 4:21 pm
by Th4Sh4rk
Ok I have tried everything. Uninstall/Delete/ MSDOS delete/ install postgre seperate from PT. everything known to man. and I finally get pass the password error. now i got a new one. I've been at this for 3hours and 12 min and getting really frustrated.

This is the error I get:

Error connecting to the default PostgreSQL database:

999-SQLSTATE = IM002
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

All I'm trying to do is convert my database from PT2 to PT3. I tried the Link from PT3 under DATABSE->CONVERT.

But it says no PTv2 Databases found. So i assumed I needed to convert my PTv2 Database to PostgreSQL.

Any help ?

Thanks in Advance!!!!

Re: Database Error

PostPosted: Wed May 14, 2008 4:36 pm
by ptrack pat
What value do you have selected in the "ODBC Entry To Use" field on the PostgreSQL Settings window?

Re: Database Error

PostPosted: Wed May 14, 2008 4:43 pm
by Th4Sh4rk
PostgreSQL Unicode.

ENCODING: UNICODE

Re: Database Error

PostPosted: Wed May 14, 2008 4:46 pm
by Th4Sh4rk
ok I reinstalled The ODBC under the PT3 folder and i got passed that now i have FATAL: role "postgre" does not exist.

Re: Database Error

PostPosted: Wed May 14, 2008 4:49 pm
by Th4Sh4rk
ok well i give up. i found that i can just manually import all the hands from the "processed" folder in PTv2. lol. what a waste of 4 hours. well thanks to everyone that helped!

Re: Database Error

PostPosted: Wed May 14, 2008 4:54 pm
by ptrack pat
The user name on the PostgreSQL Settings window should be "postgres" not "postgre".

Re: Database Error

PostPosted: Wed May 14, 2008 6:14 pm
by Th4Sh4rk
Haha Thanks man.