Thread: Database backend (7.4 versus 8.0) trouble ?

Hi,

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.

Any help ?

Thanks, Lothar

--
Lothar Behrens    |    Rapid Prototyping ...
Rosmarinstr 3        |
40235 Düsseldorf      |    www.lollisoft.de

> 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.

If you're able to connect with another client app could you send us mylog
output?

Regards,

Luf

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

> [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 ?

I have few experiences with ODBC on *nix boxes.
Is it ok to mix odbc.ini and odbcinst.ini (Driver option)?
I have Yes and No instead of 1 and 0 (but it couldn't be the problem).
I have Username with small "n" inside the word.
Debug and Trace are ok. I'm not sure if DebugFile is ok.
You may find debug file in /tmp/*mylog*.

I hope it helps you

Luf