Обсуждение: 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