Database Error

Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.

Database Error

Postby Th4Sh4rk » Wed May 14, 2008 4:21 pm

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!!!!
Th4Sh4rk
 
Posts: 9
Joined: Sat Mar 29, 2008 10:21 pm

Re: Database Error

Postby ptrack pat » Wed May 14, 2008 4:36 pm

What value do you have selected in the "ODBC Entry To Use" field on the PostgreSQL Settings window?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Database Error

Postby Th4Sh4rk » Wed May 14, 2008 4:43 pm

PostgreSQL Unicode.

ENCODING: UNICODE
Th4Sh4rk
 
Posts: 9
Joined: Sat Mar 29, 2008 10:21 pm

Re: Database Error

Postby Th4Sh4rk » Wed May 14, 2008 4:46 pm

ok I reinstalled The ODBC under the PT3 folder and i got passed that now i have FATAL: role "postgre" does not exist.
Th4Sh4rk
 
Posts: 9
Joined: Sat Mar 29, 2008 10:21 pm

Re: Database Error

Postby Th4Sh4rk » Wed May 14, 2008 4:49 pm

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!
Th4Sh4rk
 
Posts: 9
Joined: Sat Mar 29, 2008 10:21 pm

Re: Database Error

Postby ptrack pat » Wed May 14, 2008 4:54 pm

The user name on the PostgreSQL Settings window should be "postgres" not "postgre".
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Database Error

Postby Th4Sh4rk » Wed May 14, 2008 6:14 pm

Haha Thanks man.
Th4Sh4rk
 
Posts: 9
Joined: Sat Mar 29, 2008 10:21 pm


Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 21 guests

cron