Re: Postgres and dbexpress

Gabriel Monsalvo

kylix Developer

Re: Postgres and dbexpress

2003-07-28 08:07:55 PM
kylix0
Ben Hochstrasser wrote:

Quote

Gabriel Monsalvo wrote:

>i'm just starting to develop under kilyx, i have postgresql in the
>backend and when I make a dbx connection for an especific database,
>when i test on the connection always get "unable to load libsqlpg.so"

either adjust /etc/ld.so.conf (and run ldconfig) or symlink libsqlpg.so
(wasn't this supposed to be libpgsql.so?) to somewhere in /usr/lib.

i tried that too, but does not work. I check out the client libraries

for postgresql and there are installed and with symbolic link to
/usr/lib (libpq.so), this mornig tried to connect with mysql and its
works ! but i need to use postgresql if you know anything to solve this
problem i will thank you for the eternity.
Gabriel.

Ben Hochstrasser

kylix Developer

2003-07-29 02:44:03 AM

Re:Re: Postgres and dbexpress

Gabriel Monsalvo wrote:

Quote

>either adjust /etc/ld.so.conf (and run ldconfig) or symlink libsqlpg.so
>(wasn't this supposed to be libpgsql.so?) to somewhere in /usr/lib.
>
i tried that too, but does not work. I check out the client libraries
for postgresql and there are installed and with symbolic link to
/usr/lib (libpq.so), this mornig tried to connect with mysql and its
works ! but i need to use postgresql if you know anything to solve this
problem i will thank you for the eternity.
Okay...let's see:

- does psql (the interactive thingie) work on your computer? Will it work
against both localhost and the real IP?
- is there a libsqlpg.so (symlink to libsqlpg.so.1.x) in /usr/lib?
--
Ben

Gabriel Monsalvo

kylix Developer

2003-08-01 11:26:46 PM

Re:Re: Postgres and dbexpress

Ben Hochstrasser wrote:

Quote

Gabriel Monsalvo wrote:

>>either adjust /etc/ld.so.conf (and run ldconfig) or symlink libsqlpg.so
>>(wasn't this supposed to be libpgsql.so?) to somewhere in /usr/lib.
>>
>
>i tried that too, but does not work. I check out the client libraries
>for postgresql and there are installed and with symbolic link to
>/usr/lib (libpq.so), this mornig tried to connect with mysql and its
>works ! but i need to use postgresql if you know anything to solve this
>problem i will thank you for the eternity.

Okay...let's see:

- does psql (the interactive thingie) work on your computer? Will it work
against both localhost and the real IP?

- is there a libsqlpg.so (symlink to libsqlpg.so.1.x) in /usr/lib?

hi again Ben: thanks for your answer and soory for the delay but i was

ill (get a cold).
i try out the psql -U "user" -h db-host database and works fine.
the library libsqlpg.so is in:
/usr/lib/libsqlpg.so
/usr/local/kylix3/bin/libsqlpg.so
/usr/local/kylix3/bin/libsqlpg.so.1.0
and /usr/lib/libsqlpg.so is a symlink.
Gabriel.

{smallsort}

Ben Hochstrasser

kylix Developer

2003-08-02 08:08:26 AM

Re:Re: Postgres and dbexpress

Gabriel Monsalvo wrote:

Quote

hi again Ben: thanks for your answer and soory for the delay but i was
ill (get a cold).
PS: I hope you're doing better in the meantime. (Colds in summer are ewwww.

Colds in winter are only eww.)
--
Ben