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

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

From: "Topo Gigio " <topo_gigio_agudos(at)lycos(dot)co(dot)uk>
To: <pgsql-cygwin(at)postgresql(dot)org>
Cc: frank(at)mail(dot)wvnet(dot)edu
Subject: Re: Re: MS-Access in PostgreSQL ... I can ´t...
Date: 2004-04-09 05:41:46
Message-ID: 1081489306004706@lycos-europe.com (view raw or flat)
Thread:
Lists: pgsql-cygwin
Friends,

Thank for your help. After this, I installed pqsqlodbc, but i cant see the fields where put database ACCESS
(MDB), or path this file. Could you help me, please, if is possible?

My configuration: Athlon Barton 2.5 Ghz, HD 40, 512MB. Im using windows xp professional, cygwin, cygipc, 
pgAdminII v 1.16, Access XP. Localhost and port number is 5432.

Before, Im using ODBC Microsoft, maybe this its one problem, too.

Im looking for your reply.

Topo_Gigio_Agudos.


------- Original message -------
From: Frank Seesink <frank(at)mail(dot)wvnet(dot)edu>
Date: Thu, 08 Apr 2004 23:24:55 -0400
Subject: Re: [CYGWIN] MS-Access in PostgreSQL ... I can t...

Topo,

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 cant. 
> 
> I just installed MDAC from Microsoft, but I cant 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  
> 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:
> 
> 
>>Hello,
>>         I need to connect MS-ACCESS inside my PGADMIN (Postgresql). I 
>>used   Tools>, selected database (directly or by ODBC), clicked button 
>>connect, but doesnt appear nothing, nothing
>>to do.
>>
>>         For example: Ill 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
>>can?
> 
> 
> 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


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Lycos Email has 10 MB of FREE storage space. http://mail.lycos.co.uk


Responses

pgsql-cygwin by date

Next:From: =?ISO-8859-1?Q?Kasimir_M=FCller?=Date: 2004-04-09 10:33:44
Subject: Re: [CYGWIN] MS-Access in PostgreSQL ... I can ´t...
Previous:From: Frank SeesinkDate: 2004-04-09 03:24:55
Subject: Re: MS-Access in PostgreSQL ... I can ´t...

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