Skip site navigation (1) Skip section navigation (2)

Re: Database backend (7.4 versus 8.0) trouble ?

From: Lothar Behrens <lothar(dot)behrens(at)lollisoft(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Database backend (7.4 versus 8.0) trouble ?
Date: 2006-03-22 15:55:01
Message-ID: 692826b1c2e6e9f8306821873e9937c4@lollisoft.de (view raw or flat)
Thread:
Lists: pgsql-odbc
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



In response to

Responses

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2006-03-22 16:15:55
Subject: Re: Database backend (7.4 versus 8.0) trouble ?
Previous:From: Hiroshi SaitoDate: 2006-03-22 15:23:30
Subject: Re: Compiling psqlodbc REL-07_03_ENHANCED and 07.03.260

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group