X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2E4AF9DC806 for ; Sat, 18 Feb 2006 03:38:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 82242-07 for ; Sat, 18 Feb 2006 03:38:18 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web36810.mail.mud.yahoo.com (web36810.mail.mud.yahoo.com [209.191.85.61]) by postgresql.org (Postfix) with SMTP id 6241B9DC896 for ; Sat, 18 Feb 2006 03:38:15 -0400 (AST) Received: (qmail 8741 invoked by uid 60001); 18 Feb 2006 07:38:16 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=EzxkbxY+A1Yr+J+3V2y4xEKC9jr5rUnE0XZHBqF9O7MmFs8JjbbmgianC2JCdcSBFXSNQDJk+aeZKEa/H8x7lj45hWoy4uSRIjqI2FKEymTNIMfMQgLkhRRdrmgWG041/tmXraYYYeXFtzgajW03hmxFPS5TAx+F99Am0UoZ6p8= ; Message-ID: <20060218073816.8739.qmail@web36810.mail.mud.yahoo.com> Received: from [61.5.41.18] by web36810.mail.mud.yahoo.com via HTTP; Sat, 18 Feb 2006 07:38:16 GMT Date: Sat, 18 Feb 2006 07:38:16 +0000 (GMT) From: fathur rohman Subject: PGOLEDB Problems To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.358 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 1.358 X-Spam-Level: * X-Archive-Number: 200602/226 X-Sequence-Number: 20647 Hi Every Body, i have plan to porting my existing projects from MSSQL Server 2000 to PostgreSQL, but i'v got several problems with pgoledb when i use it with Ado component in delphi. 1. is schema displaying not supported on pgoledb, because when i used zeos (open source dbc component) they can displayed on it with format [schema].[table_name] not just [table_name]. 2. varchar and char become [MEMO] in DBGrid,whats wrong with this? 3. i'v one column in my table that using int4[] data type, but when i open it in delphi i'v got an error message "Query returned unhandled type 1007", what's should i'v to do? 4. thanks for all. My Specs : - Win 2000 Advanced Server Powered NAS - Borland Delphi 7 - PGOleDB 1.0.0.19 - PostgreSQL 8.1.1 - Intel P4 2.4 GHz, 256 MB RAM. Send instant messages to your online friends http://uk.messenger.yahoo.com