pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Postgres ODBC
2+ messages / 2 participants
[nested] [flat]
* Re: Postgres ODBC
@ 2000-02-14 12:32 Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2000-02-14 12:32 UTC (permalink / raw)
To: Nick Gorham <nick@easysoft.com>; +Cc: PostgreSQL-development <pgsql-hackers@postgreSQL.org>; pgsql-interfaces
Patch applied. Thanks.
> Hi,
>
> I suspect that you are not the person to send this to, but I wasn't sure
> where else to mail it. I am the maintainer of unixODBC, and we have a
> set of code in our project that started life as the Postgres windows
> ODBC driver, which has been ported back to unix. Anyway I have just
> fixed a memory leak in the driver, and I cant see any mention of the fix
> being done in the main Postgres code, so I thougth I would let you know.
>
> Its in the statement.c module, after the COMMIT statement has been
> executed in SC_Execute, the code was
>
> /*// If we are in autocommit, we must send the commit. */
> if ( ! self->internal && CC_is_in_autocommit(conn) &&
> STMT_UPDATE(self)) {
> CC_send_query(conn, "COMMIT", NULL);
> CC_set_no_trans(conn);
> }
>
> I have changed it to
>
>
> /*// If we are in autocommit, we must send the commit. */
> if ( ! self->internal && CC_is_in_autocommit(conn) &&
> STMT_UPDATE(self)) {
> res = CC_send_query(conn, "COMMIT", NULL);
> QR_Destructor(res);
> CC_set_no_trans(conn);
> }
>
> Nick Gorham
>
>
--
Bruce Momjian | http://www.op.net/~candle
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgres ODBC
@ 2001-01-24 17:47 ltibor@mail.tiszanet.hu
0 siblings, 0 replies; 2+ messages in thread
From: ltibor@mail.tiszanet.hu @ 2001-01-24 17:47 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: rob5@megared.net.mx
> Hello,
> I've never used ODBC connections and I need to do one for a system
> I'm programing.
> I would like to know if someone could tell me step by step how to
> connect using Delphi 4.0 or MS Access to a remote postgres database
> that is runing on a Linux Red hat 7.0 server.
>
> Both Linux server and the PC are using the same LAN.
>
> I would really appreciate if you could let me know what drivers I
> need and how could I this work.
We use C++Builder with PostgreSQL. It works. Here's the main steps.
1. You have to set up a working PostgreSQL server accepting IP connections from
your local net.
2. Install PostgreSQL ODBC driver into your Windows machines. Search this list
archive for the driver location.
3. Make an ODBC DSN in the Windows Control panel with your new PostgreSQL ODBC
driver. You have to spec. the server machine, the dtabase name in the SQL server
and so. Check the advanced options for ReadOnly settings! See the archive...
4. Make a BDE "Database" for that ODBC DSN. If you have Delphi installed you
have to find BDE Administrator in the control panel to do this.
5. In Delphi try to use the created BDE "Database" as Borland says.
If you have questions doing this, ask me. If you don't like BDE, use another
tools. See archive.
There is a new PostgreSQL list: <pgsql-odbc@postgresql.org> Please use that
for new ODBC related questions.
--
Tibor Laszlo
ltibor@mail.tiszanet.hu
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-01-24 17:47 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-14 12:32 Re: Postgres ODBC Bruce Momjian <pgman@candle.pha.pa.us>
2001-01-24 17:47 Re: Postgres ODBC ltibor@mail.tiszanet.hu
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