Search found 13 matches

by zydoon
13.04.2006, 11:01
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Problems connecting with Postgres 8.1.3
Replies: 3
Views: 992

Hi Henri, for the whole story you can look at this thread: http://seegernet.koolhost.de/zeosforum/viewtopic.php?t=398&highlight= and if I may, I downloaded the trial version of postgresDAC, and used their libpq.dll (its version is 8.1.3) and it works fine. Actually I don't know if can still use ...
by zydoon
11.04.2006, 12:03
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Postgres Table inheritance
Replies: 0
Views: 516

Postgres Table inheritance

Hi all, I do have this DB schema : PARTS LENSES--> inherits PARTS SUPPLIER, and SUPPLIER_PARTS : defining the suppliers of one kind of parts (with all due foreign keys) now when INSERTING into SUPPLIER_PARTS it complains about abscence of the PARTS_ID, which of course exists. on psql : when I do &qu...
by zydoon
07.04.2006, 23:56
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Invalid UTF-8 byte sequence detected
Replies: 7
Views: 1343

Hi,
you can hardcode it the object inspector at the "properties" parameter.
by zydoon
06.04.2006, 18:22
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Invalid UTF-8 byte sequence detected
Replies: 7
Views: 1343

It's working with UTF8 too
thank you very much :)
by zydoon
06.04.2006, 18:20
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Invalid UTF-8 byte sequence detected
Replies: 7
Views: 1343

Misteriously it's working now !
the only thing I did it was a rebooot.
I'm giving it a try with UTF8 (or UNICODE whatever it is)
by zydoon
06.04.2006, 13:21
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Invalid UTF-8 byte sequence detected
Replies: 7
Views: 1343

Thank you for your reply.
It doesn't work :(
I tried it in the connectin params
and in the postgres.conf file.
in the postgres.conf client_encoding defaults to database enconding, which is UTF8 and should accept 'éè.....' caracters.
I foreced it anyway and still got the error.
Again thank you.
by zydoon
25.03.2006, 13:32
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Invalid UTF-8 byte sequence detected
Replies: 7
Views: 1343

Invalid UTF-8 byte sequence detected

Hi,
I'm developping a delphi app with pgSQL 8.1 as backend through zeosLIB 6.5.1 alpha.

Whenever I try to post some UTF8 characters I get this message :

Code: Select all

... EZSQLException with message 'SQL Error: ERROR: Invalid UTF-8 byte sequence detected near byte 0xe0'.
can someone help please ?
Thanks,
Zied.
by zydoon
05.03.2006, 00:57
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Error on connecting to a PostgreSQL8.1 DB
Replies: 11
Views: 3493

God Bless you :)
I did what you said.
I renamed the libpq7.4.dll to libpq.dll and now I can connect TZConnection to my latest postgresSQL (8.1.3).

Thank you again.
by zydoon
04.03.2006, 19:38
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Error on connecting to a PostgreSQL8.1 DB
Replies: 11
Views: 3493

Hi again,
I brought the libpq.dll from postgreSQL\bin directory and renamed it to all sort of libpqXX.dll in vain.
I give up !
by zydoon
04.03.2006, 19:00
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Error on connecting to a PostgreSQL8.1 DB
Replies: 11
Views: 3493

Hi again,

i tried to rename libpq8x.dll to libpq.dll, now Delphi sees it ubt bring me back the "access violation" error.
any other suggestion ?

my box : Win XP Home SP2, Delphi 2005 architect update 3, postgreSQL 8.1.3
by zydoon
04.03.2006, 18:56
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Error on connecting to a PostgreSQL8.1 DB
Replies: 11
Views: 3493

Sorry guys,
I got the latest version from CVS.
Now, I copied all the dll (for pgSQL) to windows\system32
delphi complains about not finding libpq81.dll and libpq.dll.
Delphi is correct about libpq.dll it doesn't exist.
can someone help ?
by zydoon
02.03.2006, 15:02
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Error on connecting to a PostgreSQL8.1 DB
Replies: 11
Views: 3493

getting latest version

Hi,
I do have the same problem with version zeosdbo-6.5.1-alpha_cvs_13-10-2005, can someone please tell me how to get the latest version from CVS ?
thanks,
Zydoon.
by zydoon
02.03.2006, 11:51
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Access Violation (Delphi 6, 6.5.1 alpha CVS as of 13/10/2005
Replies: 2
Views: 881

Same problem

Hi,
i do have the same prblem on delphi2005.
my postgres is 8.1 and my zeosdbo is 6.5.1 alpha cvs 13/10/2005.
It seems that it needs an upgrade.
someone can tell me please how can I get the latest cvs build ?
Thanks,
Zydoon.