Thread: Hello, I am a newbie on Postgres !

Hello, I am a newbie on Postgres !

From
Jean MAURICE
Date:
Hello everyone,

my name is Jean. I live in Grenoble a town in France (in Europe). I am 57. My
old computer was under W98 and I have bought a brand new one under W7-64.

I am a fan and I work with Foxpro and VisualFoxpro since 1988. I work as a
freelance and I still have customers under DOS. I also teach Fortran and C in
high tech companies. It's because I work with old version of Fox that my
nickname was given to me on the VFP mailing list as a contraction of Fox and
Fossile !

VFP is an excellent client to SQL databases and I want to learn to use an
'external' database. And if I am supposed to be an expert in SQL, triggers,
stored procedures, .... I know NOTHING about Windows, ODBC, and Postgres. So I
hope I am on the right list !!!

My first question is about ODBC : reading the docs and sites, I found I need
ODBC. I found a place in Windows (data sources) that says : ODBC drivers must
delivered by the 'database vendor'. Is there a standard ODBC driver for 64 bits
systems ? If yes where can I download it ?

best regards
The Foxil

Re: Hello, I am a newbie on Postgres !

From
Andreas
Date:
Am 07.04.2012 21:19, schrieb Jean MAURICE:
>
> My first question is about ODBC : reading the docs and sites, I found
> I need ODBC. I found a place in Windows (data sources) that says :
> ODBC drivers must delivered by the 'database vendor'. Is there a
> standard ODBC driver for 64 bits systems ? If yes where can I download
> it ?

Have you considered to look for it on the PostgreSQL web site?
http://www.postgresql.org/ftp/odbc/versions/msi/

If you install the PostgreSQL server on your box for playing around
there is a program called stackbuilder that comes up after the main PG
install is finished. With stackbuilder you can add additional packages
among which is the ODBC driver but usually not the most recent version
though.

I'm not quiite sure if you really need the 64bit version of the driver
but it wouldn' hurt, I guess.

BTW there is a specific mailing list for the ODBC driver, too.


regards
a.

Re: Hello, I am a newbie on Postgres !

From
Jean MAURICE
Date:
I tried both methods, got some DLLs. But nothing appears in the 'ODBC Manager' inside 'Configuration Panel' (I apologize but I must guess the english names from the french ones !).
Have I missed something ?

I posted the same question on pgsql-odbc@postgresql.org !

Best Regards
The Foxil