Re: About MS Access -> Postgresql Upsizing toolkit error

[oscar <os...@el...>]

About MS Access -> Postgresql and ODBC (Another answer)Dear Antonio,

I am trying to use your 'upsizing toolkit'.

After i select 'the most simple database in the world' (using Access97) =
I get the following error

Error 3021
no current record

The error occurs after clicking 'Amend Parametres'.
As far as i understand I have followed your instruction as mentioned on =
your site.

Any idea what this means?

The Pg ODBC driver is installed and works.

Thanks for your help in advance.

Regards,


Oscar
  ----- Message d'origine -----=20
  De : Administrador=20
  =C0 : 'sql...@li...'=20
  Envoy=E9 : jeudi 21 juin 2001 10:17
  Objet : About MS Access -> Postgresql and ODBC (Another answer)


  Also, if anybody has interest about the "Upsizing Toolkit": You can =
visit:=20

  http://dspace.dial.pipex.com/boylesa/=20



  Antonio Gallardo.=20




    -----Mensaje original-----=20
    De:     Oscar Buijten [SMTP:os...@el...]=20
    Enviado el:     jueves 21 de junio de 2001 1:28=20
    Para:   sql...@li...=20
    Asunto: Re: Postgresql and ODBC > MsAccess (The answer)=20

    For those who are interested:=20

    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/=20
    Download the .html and .txt files there for your reference.=20

    Then move to full/=20

    and download: psqlodbc-07_01_0005.zip=20

    unzip, doubleclick and off you go.=20

    To access your Pg Dbase from MsAccess97:=20

    Open a new database, in tables click on new.=20
    Select: attach table and click OK.=20
    A new window will open. Fromfile type, select: ODBC=20
    A new window will open.=20
    Next to the DSN name field you click on NEW.=20
    A new window will open. Select PostgreSQL, click next=20
    Now fill in the name of the new DSN entry you are about to make.=20
    The name of the Dbase you are going to access on Postgrqsql will do =
in most cases.=20
    Click on next and then on finish.=20
    A new window will open.=20
    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!=20

    Enjoy,=20

    Oscar=20



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



      Hello all,=20

      Realising that thismay not be the perfect place to ask my question =
I want to give it a try anyway.=20
      I currently have information stored in a Access97 database.=20
      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?=20

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

      Does anyone has a good answer on this?=20

      Thanks in advance!=20

      Regards,=20

      Oscar=20
      =
________________________________________________________________________ =


      Oscar Buijten=20

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

      http://www.elbie.com <<Archivo: ATT00001.htm>>=20