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=20
(darwin-powerpc) and got these error message:

Error in lbQuery: (SQLConnect()) IM002: 201 - Missing server name,=20
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 |=09
40235 Düsseldorf | www.lollisoft.de


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Database backend (7.4 versus 8.0) trouble ?

> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

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=20
ODBC issue.

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

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

[lbDMF]
Driver =3D /usr/local/lib/psqlodbc.so
Description =3D Configuration for DMF
Servername =3D jedi
UserName =3D dba
Password =3D trainres
Database =3D lbdmf
Port =3D 5432
Protocol =3D 6.4
BoolsAsChar =3D 0
ShowSystemTables =3D 1
TrueIsMinus1 =3D 1
Trace =3D 1
TraceFile =3D ~/lbDMF.log
Debug =3D 1
DebugFile =3D ~/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=20
> mylog
> output?
>
> Regards,
>
> Luf
>
>
--
Lothar Behrens | Rapid Prototyping ...
Rosmarinstr 3 |=09
40235 Düsseldorf | www.lollisoft.de



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: Database backend (7.4 versus 8.0) trouble ?

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster