Skip site navigation (1) Skip section navigation (2)

Re: MS-Access in PostgreSQL ... I can ´t...

From: Frank Seesink <frank(at)mail(dot)wvnet(dot)edu>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: MS-Access in PostgreSQL ... I can ´t...
Date: 2004-04-09 03:24:55
Message-ID: c5552f$h8t$ (view raw, whole thread or download thread mbox)
Lists: pgsql-cygwin

Question:  What EXACTLY are you trying to do?  Quick recap, there's

	* PostgreSQL (running under Cygwin)
	* PostgreSQL ODBC driver (separate download/install)
	* pgAdmin III (latest/greatest Windows GUI client front-end...
	  to PostgreSQL ONLY!)
	* MS Access (version?)

The more details you provide, the better.  For example, what versions do 
you have of each of the above?  What about Cygwin, what version are you 
running of that?  Have you done the basics, like installing PostgreSQL 
and making sure it works properly by itself, using the pgsql client CLI?

If you're working with computers, you really need to get into a clean, 
straightforward methodology on troubleshooting to make sure you have all 
the pieces in order.  In the case of PostgreSQL, always be sure the 
basics work (using just the PostgreSQL tools themselves), and only then 
start trying to plug in more complicated things like pgAdmin III, or MS 
Access (which in turn requires using the pgODBC driver).

What are you really trying to do here?  Are you trying to store data in 
a PostgreSQL database, then hook into that data using MS Access as a 
sort of front-end?  If so, you need to make sure of the following, in order:

* Is PostgreSQL itself working ok?  Can you use pgsql to connect to and 
communicate with PostgreSQL?  How is PostgreSQL configured, using 
internal sockets and/or TCP/IP?

* Have you downloaded/installed the appropriate pgODBC driver for your 
version of PostgreSQL?  I believe you normally just want to have the 
latest installed, but check the docs.

* Have you gone into your ODBC control panel and created an ODBC 
connection to your PostgreSQL database, making sure to use an 
appropirate username/password/etc.?

Your email does not provide enough detail regarding what it is you have 
done, what it is you are doing, what versions of software you are 
running, etc.  The more info you provide, the better chance you have 
that someone on this list will understand your problem and the more 
likely you'll get a response that helps you.

Topo Gigio wrote:

> I tried, but I can´t. 
> I just installed MDAC from Microsoft, but I can´t connect MS-ACCESS. When I clicked in button Connect, 
> nothing to do, only my screen blink. This screenshort show me:
> DataSource: I put my OBDC Connection
> Below, show me: driver, driver version, user, server name (ACCESS), etc.
> Please, Could you help me, please?
> Thanks and Regards.
> Topo_Gigio
> ------- Original message ------- 
> From: Christof Glaser <gcg(at)gl(dot)aser(dot)de> 
> Date: Thu, 8 Apr 2004 10:20:56 +0200 
> Subject: Re: [CYGWIN]  MS-Access in PostgreSQL ... I can ´t.... 
> Hello,
> Am 08.04.2004 um 03:45 schrieb Topo Gigio:
>>         I need to connect MS-ACCESS inside my PGADMIN (Postgresql). I 
>>used   Tools>, selected database (directly or by ODBC), clicked button 
>>connect, but doesn´t appear nothing, nothing
>>to do.
>>         For example: I´ll read tables from MS-ACCESS, filter some 
>>fields(data) which need, load on PostgreSQL.
>>Important, I need read the data from database MS-ACCESS, not only 
>>structure. Anyway, Select and Insert? I
> You can connect to Postgres database tables from within Access (linked 
> ODBC tables).
> Then you can do "Queries" in Access and select/copy the data as you 
> like.
> I think you cannot connect to an Access database (or any other database 
> except Postgres) from
> PG-Admin, since that is designed specifically for Postgres.
> Best regards,
> Christof Glaser

In response to

pgsql-cygwin by date

Next:From: Topo Gigio Date: 2004-04-09 05:41:46
Subject: Re: Re: MS-Access in PostgreSQL ... I can ´t...
Previous:From: Topo Gigio Date: 2004-04-09 00:35:27
Subject: Re: Re: MS-Access in PostgreSQL ... I can ´t....

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group