Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DFA969F9EED for ; Sat, 9 Dec 2006 17:47:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 60653-01 for ; Sat, 9 Dec 2006 17:47:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web90508.mail.mud.yahoo.com (web90508.mail.mud.yahoo.com [216.252.100.175]) by postgresql.org (Postfix) with SMTP id 723229F9C35 for ; Sat, 9 Dec 2006 17:47:39 -0400 (AST) Received: (qmail 79653 invoked by uid 60001); 9 Dec 2006 21:47:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=jSDpdh1IvIyVCZaceC6E8jd9bJaeQ3aGtqDUiCQgia7TCboK95mKtPLng7H21UZJRVzND0kL1CD32leRaxihy9Ud0xhEftGIoB1JzYL3weeM2X1nhAEWw+cXLblnAZCpeDuDscv5gHhgZrGeQ49L1uwu9RhalxEvIx1O0FOOOds=; X-YMail-OSG: 9ZSETEYVM1m_yjha8nZsZuyF31YgG0fTJ1ZTAVnVH5sJ44ZFbtsrXWL_pZESdvB7x0bSk6LDsexSO7Z_1HplZ8Ju2N_rRrhDf16SPM2ovedyYUnWQcEUlw-- Received: from [70.19.76.226] by web90508.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 13:47:37 PST Date: Sat, 9 Dec 2006 13:47:37 -0800 (PST) From: Philippe Salama Subject: Re: which ODBC to install To: Shoaib Mir Cc: PostgreSQL Admin In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-712194764-1165700857=:79061" Content-Transfer-Encoding: 8bit Message-ID: <658427.79061.qm@web90508.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.258 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_40_50, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200612/119 X-Sequence-Number: 23911 --0-712194764-1165700857=:79061 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Thanks Shoaib. You are perfectly correct! After I installed postgresql, but without installing any odbc driver, I went to MS Access, and found both the ANSI and the Unicode driver. I think I chose ANSI, ... I was able to link to all the tables which the Celko script defined, and I was able to browse the test data in those tables, and yet PG explorer gave some kind of error when I tried to browse, and I could not for the life of me see where PGAdmin allows me to browse tables. But, anyway I am making progress, and I have the latest postgresql installed, and MS Access can link to the tables. Thanks, all! Shoaib Mir wrote: Once you have installed PostgreSQL you can now use the ANSI or Unicode ODBC driver from the ODBC driver manager in Windows as it gets installed automatically during installation. Thanks, ---------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 12/10/06, Philippe Salama wrote: I just installed 8.2.1 postgresql. Now I want an odbc driver to work on my Dell XP with MS Access. The choices are very confusing. Please advise. I am not a rocket scientist. Thanks! --------------------------------- Want to start your own business? Learn how on Yahoo! Small Business. --------------------------------- Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers. --0-712194764-1165700857=:79061 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Thanks Shoaib. You are perfectly correct! After I installed postgresql, but without installing any odbc driver, I went to MS Access, and found both the ANSI and the Unicode driver. I think I chose ANSI, ...  I was able to link to all the tables which the Celko script defined, and I was able to browse the test data in those tables, and yet PG explorer gave some kind of error when I tried to browse, and I could not for the life of me see where PGAdmin allows me to browse tables.

But, anyway I am making progress, and I have the latest postgresql installed, and MS Access can link to the tables.  Thanks, all!

Shoaib Mir <shoaibmir@gmail.com> wrote:
Once you have installed PostgreSQL you can now use the ANSI or Unicode ODBC driver from the ODBC driver manager in Windows as it gets installed automatically during installation.

Thanks,
----------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/10/06, Philippe Salama <karebacnyc@yahoo.com> wrote:
I just installed 8.2.1 postgresql. Now I want an odbc driver to work on my Dell XP with MS Access.  The choices are very confusing. Please advise. I am not a rocket scientist.  Thanks!

Want to start your own business? Learn how on Yahoo! Small Business.



Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers. --0-712194764-1165700857=:79061--