Page 1 of 1

Unable to connect to database

PostPosted: Thu Jun 05, 2008 4:51 am
by Ahriman
Hello,

I have installed PostgreSQL Version 8.2.7 and the ODBC driver. If I want to start PT2 the following error message appears:

"Unable to connect to the database

999 - SQLSTATE = IM002

[Microsoft][ODBC Drive Manager] Der Datenquellname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben"

If I want to convert a database the following message appears:

[ img ]


Many thanks for your help

Re: Unable to connect to database

PostPosted: Thu Jun 05, 2008 8:46 am
by ptrack pat
[Microsoft][ODBC Drive Manager] Der Datenquellname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben"


Please translate this.

On the PostgreSQL Settings window, what value do you have selected in the "ODBC Entry To Use" field? It should be PostgreSQL Unicode.

Re: Unable to connect to database

PostPosted: Thu Jun 05, 2008 12:50 pm
by Ahriman
yes the value is PostgreSQL Unicode

The translation is:

The data source name wasn't found and there is no standard driver choosen.

Re: Unable to connect to database

PostPosted: Thu Jun 05, 2008 1:24 pm
by ptrack pat
From the Start menu select Settings > Control Panel > Administrative Tools > Data Sources (ODBC)

Click on the Drivers tab of the window that opens.

Do you see PostgreSQL Unicode in the list? If so, what is the version number?

Re: Unable to connect to database

PostPosted: Fri Jun 06, 2008 5:19 am
by Ahriman
Yes I see it. The version number is 8.03.01.00

Re: Unable to connect to database

PostPosted: Fri Jun 06, 2008 8:31 am
by ptrack pat
Go to the Start > Settings > Control Panel > Admin Tools > Services window.

Find PostgreSQL 8.2 in the list. Does it say it's started? If not, try to start it. Does it give an error?

If it's running, go to the Start menu and select Programs > PostgreSQL 8.2. > pgAdmin III

On the window that opens, right-click the red X at the top left part of the window and select "Connect" from the popup menu.

Enter your password.

What happens? Does it give an error or do you see a list of databases?

Re: Unable to connect to database

PostPosted: Fri Jun 06, 2008 9:43 am
by Ahriman
"PostgreSQL Database Server 8.2" is started but there doesn't stand "Lokales System" which means "local system". Is that a problem?

[ img ]

If I click connect and enter my passwort I don't get an error message but there also isn't a list of databases but look on your own:

[ img ]

Re: Unable to connect to database

PostPosted: Fri Jun 06, 2008 10:35 am
by ptrack pat
I don't know what is causing this.

Use the Start > Settings > Control Panel > Add or Remove Programs window to uninstall 8.2.7 of PostgreSQL
Then delete the remnants of the c:\program files\postgresql\8.2\data folder.

From the Start menu select Run. Type COMMAND on the next window and hit OK to open a DOS window. Type:

net user postgres /delete

and hit ENTER. Then type EXIT to close the window.

Finally, install the latest version of PostgreSQL, v8.3, download it here:
http://wwwmaster.postgresql.org/downloa ... .3.1-1.zip

Then do this extra step:
archives/PT2/viewtopic.php?t=24880

And then try it again.