Postgres Pro
Downloads
Home   >   mailing lists

Thread: kylix3 connection problem

kylix3 connection problem

From
"daniel"
Date:
allo,
 
I am stalling over this kylix3 connection problem with postgresql 7.2 in Redhat7.3
 
I had unmarked the line in
[1] pg_hba.conf in /usr/local/pgsql/data1
host all 127.0.0.1 255.255.255.255 trust.
[2] postgres.conf 
tcpip__sock = true
 
[3] in the hidden dbxdriver file,
VendorLib = libpq.so.2
 
[4] in kylix3 dbexpress SQLConnection properties :-
hostname localhost
username daniel
password daniel
 
[5] the postmaster is started via :-
daniel@localhost daniel]$ pg_ctl start -D /usr/local/pgsql/data1 > logfile 2>&1 &
 
i hope to get some experienced postgresql_kylix3 to help me out of this loop.
 
ciao
daniel
 
 

Re: kylix3 connection problem

From
Date:
Hello,

>I am stalling over this kylix3 connection problem with postgresql 7.2 in
Redhat7.3
Can you gimme exact error message?
> 4] in kylix3 dbexpress SQLConnection properties :-
>hostname localhost
>username daniel
>password daniel
I don't know much about dbexpress, but I am not sure you have created
database
(you have to mention name of the database somewhere) with username&password
daniel

I am using Kylix2 (and Delphi6) and zeoslib components
(http://www.zeoslib.net)
with PostgreSQL 7.3.4 and have no problems at all.
Consider to switch to open source components and you will always have
someone to ask your questions.
..or at least you will be able to look at the source and, hopefully, will
find solution yourself.

I recommend you to get latest stable source from Postgresql.org & latest
stable zeosdbo version (currently 6.01.2).


Please cc or bcc me if you want to contact me.

Good Luck & Regards,
Alvis

Re: kylix3 connection problem

From
"daniel"
Date:
allo

i had downloaded the zeos - dbo version 6 and in kylix 3 did the build and
got the err dialog with :-
cannot load bplZComponent and bplZDbc.so: can't opened shared object file .

what do you think is missing and what can i do.

ciao
daniel

----- Original Message -----
From: <alvis@piladzi-2.biz>
To: <pgsql-chat@postgresql.org>
Cc: <mrdaniel@singnet.com.sg>
Sent: Friday, August 22, 2003 7:20 PM
Subject: Re: [pgsql-chat] kylix3 connection problem


> Hello,
>
> >I am stalling over this kylix3 connection problem with postgresql 7.2 in
> Redhat7.3
> Can you gimme exact error message?
> > 4] in kylix3 dbexpress SQLConnection properties :-
> >hostname localhost
> >username daniel
> >password daniel
> I don't know much about dbexpress, but I am not sure you have created
> database
> (you have to mention name of the database somewhere) with
username&password
> daniel
>
> I am using Kylix2 (and Delphi6) and zeoslib components
> (http://www.zeoslib.net)
> with PostgreSQL 7.3.4 and have no problems at all.
> Consider to switch to open source components and you will always have
> someone to ask your questions.
> ..or at least you will be able to look at the source and, hopefully, will
> find solution yourself.
>
> I recommend you to get latest stable source from Postgresql.org & latest
> stable zeosdbo version (currently 6.01.2).
>
>
> Please cc or bcc me if you want to contact me.
>
> Good Luck & Regards,
> Alvis
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org

Re: kylix3 connection problem

From
Date:
----- Original Message -----
From: "daniel" <mrdaniel@singnet.com.sg>
To: <alvis@piladzi-2.biz>; <pgsql-chat@postgresql.org>
Sent: Saturday, August 23, 2003 6:13 AM
Subject: Re: [pgsql-chat] kylix3 connection problem


> allo
>
> i had downloaded the zeos - dbo version 6 and in kylix 3 did the build and
> got the err dialog with :-
> cannot load bplZComponent and bplZDbc.so: can't opened shared object file
.
>
> what do you think is missing and what can i do.
>
> ciao
> daniel
>
Hello,

You should try to install zeosdbo v.5.5.0 stable:
1)IMHO old 5.5 branch is currently much better .
(for example, you have TZMonitor + I have kind of my own extension for
v5.5.).
2)You have to choose between ver. 5.5 and 6.0, but you have to try both
versions yourself to make your decision.
3)Hopefully you will learn how to install 6.0 while installing 5.5. ;-)

Instructions for 5.5. install:

-begin cut of Linux Install
LINUX INSTALL
1. Unpack the archive with components
2. Unpack XXX/kylix/desprop50562.tar.gz into kylix/lib directory
(Files dbdesign.dcp and std.dcp should be there).
For support PostgreSQL or MySql servers must be intalled
mysql-shared-xxx.rpm or postgresql-libs-xxx.rpm packages
or this servers must be compilled and installed with client shared
libraries.
3. Edit Zeos.inc file. You may set there you language,
maximum quantity of supported memo fields, etc.
4. Add to Kylix Library Path pathes to XXX, XXX\common, XXX\dbase,
where XXX - ZeosDBO directory.
5. Check pathes to shared libraries in ZLibXXSql.pas
6. Compile and install dpk files in the next sequence:
ZCommonK, ZDbwareK, { ZMySqlK | ZPgSqlK | ZIbSqlK}
-end of cut Linux install

HTH.

Best Regards,
alvis.