Re: Postgresql and ODBC > MsAccess (The answer)

[Oscar B. <os...@el...>]

For those who are interested:

If you would like to access your Postgresql server on your linux (or =
whatever else box) from MickeySoft Access you will need to install the =
Postgresql ODBC server. It is a piece of cake to do. Just ftp to (be =
carefull, it might be bussy on this site)

ftp.postgresql.org=20

and move to pub/
Download the .html and .txt files there for your reference.

Then move to full/

and download: psqlodbc-07_01_0005.zip

unzip, doubleclick and off you go.

To access your Pg Dbase from MsAccess97:

Open a new database, in tables click on new.
Select: attach table and click OK.
A new window will open. Fromfile type, select: ODBC
A new window will open.
Next to the DSN name field you click on NEW.
A new window will open. Select PostgreSQL, click next
Now fill in the name of the new DSN entry you are about to make.
The name of the Dbase you are going to access on Postgrqsql will do in =
most cases.
Click on next and then on finish.
A new window will open.
This one looks very simalar to the user id in SQL ledger doesn't it?
Fill in the details (you may want to peek into the advanced settings =
while you'r there) and off you go!

Enjoy,

Oscar


----- Message d'origine -----=20
  De : Oscar Buijten=20
  =C0 : sql...@li...=20
  Envoy=E9 : mercredi 20 juin 2001 12:08
  Objet : Postgresql and ODBC > MsAccess


  Hello all,

  Realising that thismay not be the perfect place to ask my question I =
want to give it a try anyway.
  I currently have information stored in a Access97 database.
  Part of this information I would need to transfer to Postgresql (on a =
linux box (Mandrake 8.0) to use it in the SQL-ledger.

  Question is: how to do this?

  I assume I would need to do it using ODBC, but I have no clue what to =
install (as a driver) and
  where to install it (on the linux box or on the wondoze box).

  Does anyone has a good answer on this?

  Thanks in advance!

  Regards,

  Oscar
  =
________________________________________________________________________

  Oscar Buijten

  Tel:     +33.4.67.57.97.45
  Fax:    +33.4.67.57.97.46
  GSM: +33.6.20.84.15.22
  Email: os...@el...

  http://www.elbie.com