Re: Database backend (7.4 versus 8.0) trouble ?

Am 22.03.2006 um 15:42 schrieb Ludek Finstrle:

>> I am just trying PostgreSQL 8.0.2-12 on my Mac OS X 10.3
>> (darwin-powerpc) and got these error message:
>>
>> Error in lbQuery: (SQLConnect()) IM002: 201 - Missing server name,
>> port, or database name in call to CC_connect.
>>
>> If I use my old database (7.4 on Linux), I didn't get any problems.
>
> Are you able to connect to PgSQL 8.0 via psql or pgAdmin?
> You haven't told us what client OS are you using.

Oh,

it's the same on Mac OS X. Currently I am also in trouble with 7.4.
The pgAdmin tool works on both database versions. So it seems to be an
ODBC issue.

The trouble may be from installing the postgreSQL database with the
client API's.
First I saw, that it has installed iODBC. Then I have reinstalled
unixODBC package and
psqlODBC, but no success.

I also didn't get configured logging. Here is my odbc.ini setting:

[lbDMF]
Driver           = /usr/local/lib/psqlodbc.so
Description      = Configuration for DMF
Servername       = jedi
UserName         = dba
Password         = trainres
Database         = lbdmf
Port             = 5432
Protocol         = 6.4
BoolsAsChar      = 0
ShowSystemTables = 1
TrueIsMinus1     = 1
Trace            = 1
TraceFile        = ~/lbDMF.log
Debug            = 1
DebugFile        = ~/lbDMF.debug.log

Are the Trace and Debug settings valid ?

Lothar

>
> If you're able to connect with another client app could you send us
> mylog
> output?
>
> Regards,
>
> Luf
>
>
--
Lothar Behrens    |    Rapid Prototyping ...
Rosmarinstr 3        |
40235 Düsseldorf      |    www.lollisoft.de