PokerTracker

every time i start pt v2 following error message appears and then it shuts down:

unable to connect to the hand history database
160 - sqlstate = IM003

I tried different postgresql versions, but the error remains, no matter which version i am running.
For testing reasons i installed pt3, all works fine, but my pt2 version does not. i am running vista, uac is disabled and i am running as admin.

any ideas?

unable to connect to the hand history database
160 - sqlstate = IM003

Is this all it says? Isn't there more detail than this?

...due to the system failure 126 (microsoft acess driver(*.mdb)) the designated driver cannot be loaded!


thats all.

The only thing I can think of is that the registry is pointing somewhere where the driver file does not exist. Using the registry editor, REGEDIT, go to...

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Access Driver (*.mdb)

and find out what the value of the "Driver" field is. It should be something like...

C:\WINDOWS\system32\odbcjt32.dll

Whatever it is, go to the folder where it says that file is located and see if it's there. If it's not there, search your hard drive for the existence of the file name - odbcjt32.dll - If you find it, change the value of the "Driver" and "Setup" fields to be the correct folder where you found this file.

unfortunately the driver you mentioned is where it should be.

but why is pokertracker 3 running and pt2 not?

Because PT3 works nothing like PT2 does. I don't know what else would be causing these errors with the ODBC drivers, this is a problem with your computer, not the software. Try reinstalling these Microsoft Data Access Drivers (MDAC)...

http://www.microsoft.com/downloads/deta ... laylang=en

Also, I just looked at the code. You would only get an error like this if your default database is an Access database, not PostgreSQL. Are you sure you have converted your PT2 to PostgreSQL? Using the registry editor again, go to...

HKEY_LOCAL_MACHINE\SOFTWARE\PTrack

And under that you should see entries like 2DB1, 2DB2, 2DB3, etc. Scroll through these entries, you will see on the right side a value "Default". If it's a 1 then that's your default database PT2 is trying to open. How many of these "2BBxx" values do you have and for each one, what is the value of the "Filename" field. For an Access database, it will be an actual file name, for PostgreSQL, it will just be the name of the database.

hi,

i have only one db in my regedit, named db1. and its default value is "1".
the filename is c:\program files\poker tracker v2\ptrack.mdb

P.S.: what do you mean with converted my pt2 to postgres? my pt2 doesnt start, so i cannot convert anything or did i miss something? i didnt convert anything.

You said in the initial post that you had installed PostgreSQL so I assumed you were using that but you are still using the default Access database.

Did you try installing those MDAC drivers? What happened?

With PT closed...

1. Go to the Start > Settings > Control Panel > Administrative Tools > ODBC Data Sources window.

2. On the window that opens, click the System DSN tab.

3. Click on the entry PTRACKHH and click the "Configure..." button.

4. Click the "Repair..." button on the next window.

5. On the next window that pops up, click ok.

What happens when you do this? If you get the same error, try repairing the entry called "PTRACK". Does this give the same error? If you get errors then the ODBC drivers have somehow been corrupted on your computer.

nothing happend after installing those drivers. i was asked if i want to install, clicked yes and the window dissapeared.

3. i cannot open the configure button because i get an error message, so i think you are right with these odbc drivers, whatever that is.

What is the error message? I really don't know what to tell you short of reinstalling Windows or reformatting your computer.

Also, search your entire hard drive for the existence of the file "odbcjt32.dll". Do you find more than one file of this name in different folders? If so, what folders is this file found in?