From karebacnyc@yahoo.com Sat Dec 9 20:48:51 2006 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D49EA9FA19B for ; Sat, 9 Dec 2006 16:48:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 21962-03 for ; Sat, 9 Dec 2006 16:48:43 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web90504.mail.mud.yahoo.com (web90504.mail.mud.yahoo.com [216.252.100.171]) by postgresql.org (Postfix) with SMTP id A6EE89F9FDA for ; Sat, 9 Dec 2006 16:48:46 -0400 (AST) Received: (qmail 67877 invoked by uid 60001); 9 Dec 2006 20:48:44 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=dfilYYw2quFwXleMAGNHCXKTEAoo5k7lH/dmYNUKvD+PtVgLrlrRlyBAGmBvYadMVF9qa0SXjn1x/uQHo9ItUMLZnEuE6CbQo4mO8CmgofEXPslrOWJcLh+LqJ7h7x8O/x07Dm+Xp1D4bi6Vljlhj+2e+tr28OrSXkSki65X9lg=; X-YMail-OSG: HX4uzWsVM1ncJ6trqcPvZhJOimV.oDus7dd5hWOA_q5DrS5Bm3I9O7GYH1cebEaLPOyZl1PxzudSAq2jr6HhBUEY8PIvhi.2l56kdNkqOU.9u171Z.OYQw-- Received: from [70.19.76.226] by web90504.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 12:48:44 PST Date: Sat, 9 Dec 2006 12:48:44 -0800 (PST) From: Philippe Salama Subject: which ODBC to install To: PostgreSQL Admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-242158404-1165697324=:67424" Content-Transfer-Encoding: 8bit Message-ID: <927178.67424.qm@web90504.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/111 X-Sequence-Number: 23903 --0-242158404-1165697324=:67424 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-242158404-1165697324=:67424 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-242158404-1165697324=:67424-- From immaad@gmail.com Sat Dec 9 20:54:00 2006 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 59B289FA2CC for ; Sat, 9 Dec 2006 16:54:00 -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 50038-07 for ; Sat, 9 Dec 2006 16:53:51 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.189]) by postgresql.org (Postfix) with ESMTP id 5DB289FA2CB for ; Sat, 9 Dec 2006 16:53:54 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so1625922nfb for ; Sat, 09 Dec 2006 12:53:52 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=O1sSmbVV/7TPulT4L2XLOfk6XPRX+JnciQ2JazEuIgsp8Jjzm3E+n2KbYsgJxe1rdp1eusO7GEh/lV9Hjo8zBAwzSGoR2C60Jwqhx8ywlvJBmI/Sbufb5TSbuhOgwZbyjGCgVEHMh2+670Q1ZQK3kFGVF0LyAl8kddkvfgqV/Ok= Received: by 10.82.139.17 with SMTP id m17mr259917bud.1165697631787; Sat, 09 Dec 2006 12:53:51 -0800 (PST) Received: by 10.82.164.17 with HTTP; Sat, 9 Dec 2006 12:53:51 -0800 (PST) Message-ID: <1f30b80c0612091253x60f23ee4mb586de0ff1eb3864@mail.gmail.com> Date: Sun, 10 Dec 2006 01:53:51 +0500 From: imad To: "Philippe Salama" Subject: Re: which ODBC to install Cc: "PostgreSQL Admin" In-Reply-To: <927178.67424.qm@web90504.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <927178.67424.qm@web90504.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/112 X-Sequence-Number: 23904 Use this ODBC driver to connect to PostgreSQL. http://gborg.postgresql.org/project/psqlodbc/projdisplay.php Windows versions already contain ODBC drivers for MS Access. --Imad Rocket Scientist :-) 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. > > From shoaibmir@gmail.com Sat Dec 9 20:54:41 2006 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id A37769FA2CB for ; Sat, 9 Dec 2006 16:54:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 80589-03 for ; Sat, 9 Dec 2006 16:54:28 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0102.google.com (nz-out-0506.google.com [64.233.162.237]) by postgresql.org (Postfix) with ESMTP id 3F4299F9FDA for ; Sat, 9 Dec 2006 16:54:32 -0400 (AST) Received: by nz-out-0102.google.com with SMTP id i11so629355nzh for ; Sat, 09 Dec 2006 12:54:30 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=p1sj8kGot4hNteiyyUnBJftSQlp5u4YoL1pPX/MYTdNGHkLReUACqfevJ62kAptMzIJ+4+Iu6WhtYzNUqkDmzZaEAutfI2f7KRUOCwBI+doHJbfOEaKk4saJaHMxLSLGyby8y71DV8nw+8OCRO8s+ObXk4vO+JvuiIryrORefDc= Received: by 10.65.192.16 with SMTP id u16mr8094550qbp.1165697670302; Sat, 09 Dec 2006 12:54:30 -0800 (PST) Received: by 10.65.206.18 with HTTP; Sat, 9 Dec 2006 12:54:30 -0800 (PST) Message-ID: Date: Sun, 10 Dec 2006 01:54:30 +0500 From: "Shoaib Mir" To: "Philippe Salama" Subject: Re: which ODBC to install Cc: "PostgreSQL Admin" In-Reply-To: <927178.67424.qm@web90504.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_46561_8790644.1165697670254" References: <927178.67424.qm@web90504.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/113 X-Sequence-Number: 23905 ------=_Part_46561_8790644.1165697670254 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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. > > ------=_Part_46561_8790644.1165697670254 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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.


------=_Part_46561_8790644.1165697670254-- From jd@commandprompt.com Sat Dec 9 20:58:46 2006 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 48FCE9FA1DA for ; Sat, 9 Dec 2006 16:58:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 82822-05 for ; Sat, 9 Dec 2006 16:58:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 9AF2B9FA19B for ; Sat, 9 Dec 2006 16:58:41 -0400 (AST) Received: from [192.168.1.95] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id kB9KwfIL015435 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Sat, 9 Dec 2006 12:58:42 -0800 Subject: Re: which ODBC to install From: "Joshua D. Drake" To: Philippe Salama Cc: PostgreSQL Admin In-Reply-To: <927178.67424.qm@web90504.mail.mud.yahoo.com> References: <927178.67424.qm@web90504.mail.mud.yahoo.com> Content-Type: text/plain Organization: Command Prompt, Inc. Date: Sat, 09 Dec 2006 13:00:30 -0800 Message-Id: <1165698030.25137.6.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Sat, 09 Dec 2006 12:58:42 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/114 X-Sequence-Number: 23906 On Sat, 2006-12-09 at 12:48 -0800, 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! http://projects.commandprompt.com/public/odbcng/browser/binaries/mODBC_Installer%28beta_00.99.0088%29.msi Sincerely, Joshua D. Drake > > > > ______________________________________________________________________ > Want to start your own business? Learn how on Yahoo! Small Business. -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate From karebacnyc@yahoo.com Sat Dec 9 21:15:40 2006 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id E5C219F9EED for ; Sat, 9 Dec 2006 17:15:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 25434-02 for ; Sat, 9 Dec 2006 17:15:31 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web90505.mail.mud.yahoo.com (web90505.mail.mud.yahoo.com [216.252.100.172]) by postgresql.org (Postfix) with SMTP id 23D839F9C35 for ; Sat, 9 Dec 2006 17:15:35 -0400 (AST) Received: (qmail 72404 invoked by uid 60001); 9 Dec 2006 21:15:33 -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=zbXBGV+zCN65SRv3clse2w8iqD6qXgE3LKrS5WT6Yp+8RMApni0wERxkUbBEDZElwBZrr+K7n17fbXJIRe0YCZ5+irU15h1IIvdzF/npnpsO8rmWKdrW/jNdbuJK/r4YM8kOn8N7YFPhBJSMr353SVBXgPcPPAmx4j6XkWy161s=; X-YMail-OSG: FTJYUl8VM1kIPplOfPfVdUpmx_UPzi2Iw.pJGN.E0fBhaTqTySfVK3sosSNe7xfOK9dPdAwS5ePxvsx1nIDdetoGoai482BfYv8hePrw.XrJOPrP2yr8jw-- Received: from [70.19.76.226] by web90505.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 13:15:33 PST Date: Sat, 9 Dec 2006 13:15:33 -0800 (PST) From: Philippe Salama Subject: Re: which ODBC to install To: "Joshua D. Drake" Cc: PostgreSQL Admin In-Reply-To: <1165698030.25137.6.camel@localhost.localdomain> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1603368499-1165698933=:71776" Content-Transfer-Encoding: 8bit Message-ID: <171568.71776.qm@web90505.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.853 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200612/116 X-Sequence-Number: 23908 --0-1603368499-1165698933=:71776 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Thanks Joshua, but that link is about as clear as mud to a beginner like me. And another post explains that the ODBC was already installed along with postgresql. All I want to do is connect with MS Access. By the way. I already have PGExplorer, and right away, it connected and showed me the Celko tables installed by the script I was given. BUT, there seems to be no data in the tables.?? "Joshua D. Drake" wrote: On Sat, 2006-12-09 at 12:48 -0800, 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! http://projects.commandprompt.com/public/odbcng/browser/binaries/mODBC_Installer%28beta_00.99.0088%29.msi Sincerely, Joshua D. Drake > > > > ______________________________________________________________________ > Want to start your own business? Learn how on Yahoo! Small Business. -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate --------------------------------- Everyone is raving about the all-new Yahoo! Mail beta. --0-1603368499-1165698933=:71776 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Thanks Joshua, but that link is about as clear as mud to a beginner like me. And another post explains that the ODBC was already installed along with postgresql. All I want to do is connect with MS Access.

By the way. I already have PGExplorer, and right away, it connected and showed me the Celko tables installed by the script I was given. BUT, there seems to be no data in the tables.??



"Joshua D. Drake" <jd@commandprompt.com> wrote:
On Sat, 2006-12-09 at 12:48 -0800, 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!

http://projects.commandprompt.com/public/odbcng/browser/binaries/mODBC_Installer%28beta_00.99.0088%29.msi

Sincerely,

Joshua D. Drake

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

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate





Everyone is raving about the all-new Yahoo! Mail beta. --0-1603368499-1165698933=:71776-- From jd@commandprompt.com Sat Dec 9 21:23:54 2006 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DA4769F9EED for ; Sat, 9 Dec 2006 17:23:54 -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 55771-07 for ; Sat, 9 Dec 2006 17:23:43 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id D6D0B9F9C35 for ; Sat, 9 Dec 2006 17:23:46 -0400 (AST) Received: from [192.168.1.95] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id kB9LNlaF015929 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Sat, 9 Dec 2006 13:23:47 -0800 Subject: Re: which ODBC to install From: "Joshua D. Drake" To: Philippe Salama Cc: PostgreSQL Admin In-Reply-To: <171568.71776.qm@web90505.mail.mud.yahoo.com> References: <171568.71776.qm@web90505.mail.mud.yahoo.com> Content-Type: text/plain Organization: Command Prompt, Inc. Date: Sat, 09 Dec 2006 13:25:38 -0800 Message-Id: <1165699538.25137.15.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Sat, 09 Dec 2006 13:23:48 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/117 X-Sequence-Number: 23909 On Sat, 2006-12-09 at 13:15 -0800, Philippe Salama wrote: > Thanks Joshua, but that link is about as clear as mud to a beginner > like me. And another post explains that the ODBC was already installed > along with postgresql. All I want to do is connect with MS Access. O.k. your question is a little broad. If you want to connect with MS Access, you need to configure a DSN within Windows that uses a PostgreSQL ODBC driver. Once your DSN is configured, you should be able to connect to PostgreSQL. That is of course assuming that you have configured PostgreSQL to allow connections, but one step at a time. Here are some docs to help you on the Windows side. http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.odbc.doc/odbcmst71.htm Sincerely, Joshua D. Drake > > By the way. I already have PGExplorer, and right away, it connected > and showed me the Celko tables installed by the script I was given. > BUT, there seems to be no data in the tables.?? > > > > "Joshua D. Drake" wrote: > On Sat, 2006-12-09 at 12:48 -0800, 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! > > http://projects.commandprompt.com/public/odbcng/browser/binaries/mODBC_Installer%28beta_00.99.0088%29.msi > > Sincerely, > > Joshua D. Drake > > > > > > > > > > ______________________________________________________________________ > > Want to start your own business? Learn how on Yahoo! Small > Business. > -- > > === The PostgreSQL Company: Command Prompt, Inc. === > Sales/Support: +1.503.667.4564 || 24x7/Emergency: > +1.800.492.2240 > Providing the most comprehensive PostgreSQL solutions since > 1997 > http://www.commandprompt.com/ > > Donate to the PostgreSQL Project: > http://www.postgresql.org/about/donate > > > > > > > > ______________________________________________________________________ > Everyone is raving about the all-new Yahoo! Mail beta. -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate From karebacnyc@yahoo.com Sat Dec 9 21:47:48 2006 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-- From shoaibmir@gmail.com Sat Dec 9 21:57:35 2006 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 3445B9F9EED for ; Sat, 9 Dec 2006 17:57:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 98544-02 for ; Sat, 9 Dec 2006 17:57:29 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.183]) by postgresql.org (Postfix) with ESMTP id A89BF9F9C35 for ; Sat, 9 Dec 2006 17:57:29 -0400 (AST) Received: by py-out-1112.google.com with SMTP id a73so144104pye for ; Sat, 09 Dec 2006 13:57:28 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=cI5dkEEG886EKGR7Cf6h22IuXCmbmA1a6OYPkZ+J5huqBzPS/OgAfzyckkTCmD0tfarQQzo40kUDJmsTpqaIaC3KUnZ2dNvJfYzxODSwEyknetL6MNodGzrTjPVkPG/lq3HzbQfGKLtTmPPnsnZH/7D48RukihAkCN3hYjAIsnU= Received: by 10.64.199.2 with SMTP id w2mr8222420qbf.1165701447472; Sat, 09 Dec 2006 13:57:27 -0800 (PST) Received: by 10.65.206.18 with HTTP; Sat, 9 Dec 2006 13:57:27 -0800 (PST) Message-ID: Date: Sun, 10 Dec 2006 02:57:27 +0500 From: "Shoaib Mir" To: "Philippe Salama" Subject: Re: which ODBC to install Cc: "PostgreSQL Admin" In-Reply-To: <658427.79061.qm@web90508.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_46933_19518187.1165701447431" References: <658427.79061.qm@web90508.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/120 X-Sequence-Number: 23912 ------=_Part_46933_19518187.1165701447431 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Glad to hear that it worked out good for you :-) Thanks, --------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 12/10/06, Philippe Salama wrote: > > 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. > > > ------=_Part_46933_19518187.1165701447431 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Glad to hear that it worked out good for you :-)

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

On 12/10/06, Philippe Salama <karebacnyc@yahoo.com> wrote:
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 .


------=_Part_46933_19518187.1165701447431--