pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedwhich ODBC to install
8+ messages / 4 participants
[nested] [flat]
* which ODBC to install
@ 2006-12-09 20:48 Philippe Salama <karebacnyc@yahoo.com>
2006-12-09 20:53 ` Re: which ODBC to install imad <immaad@gmail.com>
2006-12-09 20:54 ` Re: which ODBC to install Shoaib Mir <shoaibmir@gmail.com>
2006-12-09 21:00 ` Re: which ODBC to install Joshua D. Drake <jd@commandprompt.com>
0 siblings, 3 replies; 8+ messages in thread
From: Philippe Salama @ 2006-12-09 20:48 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: which ODBC to install
2006-12-09 20:48 which ODBC to install Philippe Salama <karebacnyc@yahoo.com>
@ 2006-12-09 20:53 ` imad <immaad@gmail.com>
2 siblings, 0 replies; 8+ messages in thread
From: imad @ 2006-12-09 20:53 UTC (permalink / raw)
To: Philippe Salama <karebacnyc@yahoo.com>; +Cc: pgsql-admin
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 <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.
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: which ODBC to install
2006-12-09 20:48 which ODBC to install Philippe Salama <karebacnyc@yahoo.com>
@ 2006-12-09 20:54 ` Shoaib Mir <shoaibmir@gmail.com>
2006-12-09 21:47 ` Re: which ODBC to install Philippe Salama <karebacnyc@yahoo.com>
2 siblings, 1 reply; 8+ messages in thread
From: Shoaib Mir @ 2006-12-09 20:54 UTC (permalink / raw)
To: Philippe Salama <karebacnyc@yahoo.com>; +Cc: pgsql-admin
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.<http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/r-index;
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: which ODBC to install
2006-12-09 20:48 which ODBC to install Philippe Salama <karebacnyc@yahoo.com>
2006-12-09 20:54 ` Re: which ODBC to install Shoaib Mir <shoaibmir@gmail.com>
@ 2006-12-09 21:47 ` Philippe Salama <karebacnyc@yahoo.com>
2006-12-09 21:57 ` Re: which ODBC to install Shoaib Mir <shoaibmir@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Philippe Salama @ 2006-12-09 21:47 UTC (permalink / raw)
To: Shoaib Mir <shoaibmir@gmail.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: which ODBC to install
2006-12-09 20:48 which ODBC to install Philippe Salama <karebacnyc@yahoo.com>
2006-12-09 20:54 ` Re: which ODBC to install Shoaib Mir <shoaibmir@gmail.com>
2006-12-09 21:47 ` Re: which ODBC to install Philippe Salama <karebacnyc@yahoo.com>
@ 2006-12-09 21:57 ` Shoaib Mir <shoaibmir@gmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Shoaib Mir @ 2006-12-09 21:57 UTC (permalink / raw)
To: Philippe Salama <karebacnyc@yahoo.com>; +Cc: pgsql-admin
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.
> > <http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/r-index;
> >
>
>
> ------------------------------
> Need a quick answer? Get one in minutes from people who know. Ask your
> question on Yahoo! Answers<http://answers.yahoo.com/;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnb...;.
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: which ODBC to install
2006-12-09 20:48 which ODBC to install Philippe Salama <karebacnyc@yahoo.com>
@ 2006-12-09 21:00 ` Joshua D. Drake <jd@commandprompt.com>
2006-12-09 21:15 ` Re: which ODBC to install Philippe Salama <karebacnyc@yahoo.com>
2 siblings, 1 reply; 8+ messages in thread
From: Joshua D. Drake @ 2006-12-09 21:00 UTC (permalink / raw)
To: Philippe Salama <karebacnyc@yahoo.com>; +Cc: pgsql-admin
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%2...
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: which ODBC to install
2006-12-09 20:48 which ODBC to install Philippe Salama <karebacnyc@yahoo.com>
2006-12-09 21:00 ` Re: which ODBC to install Joshua D. Drake <jd@commandprompt.com>
@ 2006-12-09 21:15 ` Philippe Salama <karebacnyc@yahoo.com>
2006-12-09 21:25 ` Re: which ODBC to install Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 8+ messages in thread
From: Philippe Salama @ 2006-12-09 21:15 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: pgsql-admin
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%2...
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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: which ODBC to install
2006-12-09 20:48 which ODBC to install Philippe Salama <karebacnyc@yahoo.com>
2006-12-09 21:00 ` Re: which ODBC to install Joshua D. Drake <jd@commandprompt.com>
2006-12-09 21:15 ` Re: which ODBC to install Philippe Salama <karebacnyc@yahoo.com>
@ 2006-12-09 21:25 ` Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 8+ messages in thread
From: Joshua D. Drake @ 2006-12-09 21:25 UTC (permalink / raw)
To: Philippe Salama <karebacnyc@yahoo.com>; +Cc: pgsql-admin
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" <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%2...
>
> 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
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2006-12-09 21:57 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-09 20:48 which ODBC to install Philippe Salama <karebacnyc@yahoo.com>
2006-12-09 20:53 ` imad <immaad@gmail.com>
2006-12-09 20:54 ` Shoaib Mir <shoaibmir@gmail.com>
2006-12-09 21:47 ` Philippe Salama <karebacnyc@yahoo.com>
2006-12-09 21:57 ` Shoaib Mir <shoaibmir@gmail.com>
2006-12-09 21:00 ` Joshua D. Drake <jd@commandprompt.com>
2006-12-09 21:15 ` Philippe Salama <karebacnyc@yahoo.com>
2006-12-09 21:25 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox