Thread: PostgreSQL server Linux mandrake

PostgreSQL server Linux mandrake

From
Bob Bourdeau
Date:
Hello,

I have been trying to create a database on a windows machine using
Microsoft access and when trying to connect the the linux PostgreSQL
server using microsoft access to create a database on the linux server.
I cannot connect to the Postgreswl server.
Get a error message something like ODBC driver.

Using Microsoft Access is it complaint to connect to a Linux PostgreSQL ?

Do I need a special driver to connect to the linux server from a win
machine ?


Or is Oracle the only platform supported from a PostgreSQl server ?

Thanks

Rob



Re: PostgreSQL server Linux mandrake

From
terry
Date:
Rob,

You will need to use the Postgres ODBC driver for windoze that is
available from the Postgres web site.

You will not be able to create a new Postgres database from
Access, but you must do that in Linux.  After that you can create
or use Access tables by first exporting them to Postgres via the
ODBC connection.  After they are exported, you can link to them
from Access via the linked table manager to use them.

It works well, but be aware of the data type differences.

Good Luck,

terry

>>  Hello,
>>
>>  I have been trying to create a database on a windows machine
>> using Microsoft access and when trying to connect the the
>> linux PostgreSQL server using microsoft access to create a
>> database on the linux server. I cannot connect to the
>> Postgreswl server.
>>  Get a error message something like ODBC driver.
>>
>>  Using Microsoft Access is it complaint to connect to a Linux
>> PostgreSQL ?
>>
>>  Do I need a special driver to connect to the linux server
>> from a win machine ?
>>
>>
>>  Or is Oracle the only platform supported from a PostgreSQl
>> server ?
>>
>>  Thanks
>>
>>  Rob
>>
>>
>>
>>  ---------------------------(end of
>> broadcast)--------------------------- TIP 5: Have you checked
>> our extensive FAQ?
>>
>>  http://www.postgresql.org/users-lounge/docs/faq.html

--

terry

Re: PostgreSQL server Linux mandrake

From
"Peter Darley"
Date:
Terry,
    I've been under the impression that you couldn't use Access to create
tables in PostgreSQL, but I'm happy to be wrong.  How do you export the
tables?  Is it from within Access?
Thanks,
Peter Darley

-----Original Message-----
From: pgsql-odbc-owner@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org]On Behalf Of terry
Sent: Tuesday, August 06, 2002 11:54 AM
To: mount.zion@sympatico.ca; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] PostgreSQL server Linux mandrake



Rob,

You will need to use the Postgres ODBC driver for windoze that is
available from the Postgres web site.

You will not be able to create a new Postgres database from
Access, but you must do that in Linux.  After that you can create
or use Access tables by first exporting them to Postgres via the
ODBC connection.  After they are exported, you can link to them
from Access via the linked table manager to use them.

It works well, but be aware of the data type differences.

Good Luck,

terry


Re: PostgreSQL server Linux mandrake

From
terry
Date:
From the Access File menu (while the table has the focus) choose
Save As/Export, then To an External File or Database (in the next
window).  In the file dialog box select Save as type - ODBC
Databases (last option).  Enter a new table name in the next
window.  That will open the Select Data Source window.  Select
the Postgres ODBC data source (usually in Machine Data Sources.
That's it!  The table will be saved in the Postgres database that
the ODBC source is setup for.

terry

>>  Terry,
>>      I've been under the impression that you couldn't use Access
>> to create tables in PostgreSQL, but I'm happy to be wrong.
>> How do you export the tables?  Is it from within Access?
>>  Thanks,
>>  Peter Darley
>>
>>  -----Original Message-----
>>  From: pgsql-odbc-owner@postgresql.org
>>  [mailto:pgsql-odbc-owner@postgresql.org]On Behalf Of terry
>>  Sent: Tuesday, August 06, 2002 11:54 AM
>>  To: mount.zion@sympatico.ca; pgsql-odbc@postgresql.org
>>  Subject: Re: [ODBC] PostgreSQL server Linux mandrake
>>
>>
>>
>>  Rob,
>>
>>  You will need to use the Postgres ODBC driver for windoze
>> that is available from the Postgres web site.
>>
>>  You will not be able to create a new Postgres database from
>>  Access, but you must do that in Linux.  After that you can
>> create or use Access tables by first exporting them to
>> Postgres via the ODBC connection.  After they are exported,
>> you can link to them from Access via the linked table manager
>> to use them.
>>
>>  It works well, but be aware of the data type differences.
>>
>>  Good Luck,
>>
>>  terry

--

terry