pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL
4+ messages / 3 participants
[nested] [flat]
* Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL
@ 1999-01-18 22:33 Robert Chalmers <robert@chalmers.com.au>
1999-01-18 22:57 ` Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL David Hartwig <daveh@insightdist.com>
1999-01-18 23:35 ` Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL Valerio Santinelli <tanis@mediacom.it>
0 siblings, 2 replies; 4+ messages in thread
From: Robert Chalmers @ 1999-01-18 22:33 UTC (permalink / raw)
To: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>
Hi,
I'm pretty new to postgresql, but am reasonably familiar with MSAccess, and I
see here that Valerio can export tables from Access to pgsql. How is this done?
And using forms from Access related to pgsql databases?
This could be invaluable. While I'm at it, does anyone know where there might
be some sample code for a shopping cart using pgsql as the database and php3?
Thanks for any info, especialy on getting msaccess and postgresql working
together.
Robert
Valerio Santinelli wrote:
> First of all.. thanks to everybody for helping me out witht the
> "sequence" stuff. :)
>
> I've got another questions for you dudes. When using a CheckBox in a
> Form written in MSAccess that's related to a table in a
> PostgreSQL database, if I simply turn its status from ON to OFF it works
> fine, while if i'm doing the opposite it won't work.
>
> I noticed that when exporting the table from MSAccess to PostgreSQL the
> "yes/no" fields all became char(1) and not boolean.. maybe this could be
> the problem.
>
> I also noticed from the logs that when updating the status from ON to
> OFF the UPDATE goes out with something like field_name='0'
> I'm not sure it should use the "'" since it's more like a numerical, no
> ?
>
> Thanks again,
>
> Valerio Santinelli
> tanis@mediacom.it
--
http://www.chalmers.com.au. Publications From China in 24 different languages.
English, French, German, Russian, Arabic, Spanish, Chinese, Burmese, Bengali,
Hindi, Indonesian, Italian, Japanese, Korean, Portuguese, Persian, Swahili,
Sinhalese, Thai, Tamil, Urdu, Vietnamese. China Books for CIBTC, Beijing.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL
1999-01-18 22:33 Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL Robert Chalmers <robert@chalmers.com.au>
@ 1999-01-18 22:57 ` David Hartwig <daveh@insightdist.com>
1 sibling, 0 replies; 4+ messages in thread
From: David Hartwig @ 1999-01-18 22:57 UTC (permalink / raw)
To: robert@chalmers.com.au; +Cc: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>
Robert Chalmers wrote:
> Hi,
> I'm pretty new to postgresql, but am reasonably familiar with MSAccess, and I
> see here that Valerio can export tables from Access to pgsql. How is this done?
> And using forms from Access related to pgsql databases?
You need ODBC driver for PostgreSQL. (See
http://www.insightdist.com/psqlodbc) Once you connect to the backend everything
is more or less the same. There are, however, many little considerations with
regard to performance and locking. But, it doesn't take to much to get
started.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL
1999-01-18 22:33 Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL Robert Chalmers <robert@chalmers.com.au>
@ 1999-01-18 23:35 ` Valerio Santinelli <tanis@mediacom.it>
1999-01-19 01:44 ` Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL Robert Chalmers <robert@chalmers.com.au>
1 sibling, 1 reply; 4+ messages in thread
From: Valerio Santinelli @ 1999-01-18 23:35 UTC (permalink / raw)
To: robert@chalmers.com.au; +Cc: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>
Robert Chalmers wrote:
> Hi,
> I'm pretty new to postgresql, but am reasonably familiar with MSAccess, and I
> see here that Valerio can export tables from Access to pgsql. How is this done?
> And using forms from Access related to pgsql databases?
> This could be invaluable. While I'm at it, does anyone know where there might
> be some sample code for a shopping cart using pgsql as the database and php3?
>
> Thanks for any info, especialy on getting msaccess and postgresql working
> together.
Well.. I'm in a hurry so I'll be quick and concise.
To access the PostgreSQL database from a win32 machine you can simply install the
ODBC driver (there's a link on www.postgresql.org) and then you've got to configure
your database on the linux machine to accept calls through TCP/IP from other
machines. The way to do that is fully explained in the postgresql manual, but if
you need more help on the topic just ask and I'll try to explain everything in a
better way as soon as I get some time to write a full e-mail ;)
After you configured your database on the linux box, just create a new dataabse in
MSAccess and "connect external tables.." and tell him that you're using an ODBC
database. You'll be prompted to enter some details about the database, expecially
the IP address of the machine the database resides on and its name, then if
everything goes fine you'll end up with a list of the tables contained in your
postgresql database.
Have fun! :)
--
C'ya!
Valerio Santinelli a.k.a. TANiS
[tanis@mediacom.it]+:+[http://www.mediacom.it/~tanis]
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL
1999-01-18 22:33 Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL Robert Chalmers <robert@chalmers.com.au>
1999-01-18 23:35 ` Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL Valerio Santinelli <tanis@mediacom.it>
@ 1999-01-19 01:44 ` Robert Chalmers <robert@chalmers.com.au>
0 siblings, 0 replies; 4+ messages in thread
From: Robert Chalmers @ 1999-01-19 01:44 UTC (permalink / raw)
To: Valerio Santinelli <tanis@mediacom.it>; +Cc: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>; daveh@insightdist.com
Great,
Thanks chaps. I have it working. Now just have to get used to it so I am not looking up
the instructions every time I make a move.
I can load tables, and create tables in an existing database - which I have running on
the server, and probably even update the data.. but is it possible to create a database
on the server from Access? That way, I could do all the creation and updating from the
Access machine. It's not a major headache anyway. Indeed no problem at all, as I can
obviously just go to Unix, create a database, then back to Access to populate it and
update it.
Anyway, thanks for the pointers. Saved me HOURS AND HOURS ....
Best regards
Robert
Valerio Santinelli wrote:
> Robert Chalmers wrote:
>
> > Hi,
> > I'm pretty new to postgresql, but am reasonably familiar with MSAccess, and I
> > see here that Valerio can export tables from Access to pgsql. How is this done?
> > And using forms from Access related to pgsql databases?
> > This could be invaluable. While I'm at it, does anyone know where there might
> > be some sample code for a shopping cart using pgsql as the database and php3?
> >
> > Thanks for any info, especialy on getting msaccess and postgresql working
> > together.
>
> Well.. I'm in a hurry so I'll be quick and concise.
>
> To access the PostgreSQL database from a win32 machine you can simply install the
> ODBC driver (there's a link on www.postgresql.org) and then you've got to configure
> your database on the linux machine to accept calls through TCP/IP from other
> machines. The way to do that is fully explained in the postgresql manual, but if
> you need more help on the topic just ask and I'll try to explain everything in a
> better way as soon as I get some time to write a full e-mail ;)
>
> After you configured your database on the linux box, just create a new dataabse in
> MSAccess and "connect external tables.." and tell him that you're using an ODBC
> database. You'll be prompted to enter some details about the database, expecially
> the IP address of the machine the database resides on and its name, then if
> everything goes fine you'll end up with a list of the tables contained in your
> postgresql database.
>
> Have fun! :)
>
> --
>
> C'ya!
>
> Valerio Santinelli a.k.a. TANiS
> [tanis@mediacom.it]+:+[http://www.mediacom.it/~tanis]
--
http://www.chalmers.com.au. Publications From China in 24 different languages.
English, French, German, Russian, Arabic, Spanish, Chinese, Burmese, Bengali,
Hindi, Indonesian, Italian, Japanese, Korean, Portuguese, Persian, Swahili,
Sinhalese, Thai, Tamil, Urdu, Vietnamese. China Books for CIBTC, Beijing.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-01-19 01:44 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-01-18 22:33 Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL Robert Chalmers <robert@chalmers.com.au>
1999-01-18 22:57 ` David Hartwig <daveh@insightdist.com>
1999-01-18 23:35 ` Valerio Santinelli <tanis@mediacom.it>
1999-01-19 01:44 ` Robert Chalmers <robert@chalmers.com.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox