Postgres Pro
Downloads
Home   >   mailing lists

Thread: Remopte connection to POstgreSQL via ODBC

Remopte connection to POstgreSQL via ODBC

From
Zlatko Matić
Date:
Hello.
 
I just read all about TCP/IP, pg_hba.conf, listen_adresses and similar topics regarding remote TCP/IP connections,
but where can I find explanations about how to remotely connect using ODBC and DSN-less connection string.
For example, how to connect to PostgreSQL server from remote computer using MS Access and DSN-less connection string ?
Since now, I successfully conected from MS Access using DSN-less connection string but from the same machine. What if server is on a remote computer ? Is there any guide?
 
Thanks in advance,
 
Zlatko
 

Re: Remopte connection to POstgreSQL via ODBC

From
"Merlin Moncure"
Date:

This is actually a good question: I don’t think there is documentation for this on the odbc site.  Anyways, here is a small vbscript sample:

 

Dim pgCommand

set pgCommand = createObject("ADODB.Connection")

DSN = "DRIVER={PostgreSQL}; Server=localhost; Database=esp; UID=odbc_user"

pgCommand.Open DSN

 

you can very the dsn line as necessary.

 

merlin

 

From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of "Zlatko Matic"
Sent: Sunday, August 07, 2005 11:43 AM
To: pgsql-general@postgresql.org; pgsql-odbc@postgresql.org
Subject: [ODBC] Remopte connection to POstgreSQL via ODBC

 

Hello.

 

I just read all about TCP/IP, pg_hba.conf, listen_adresses and similar topics regarding remote TCP/IP connections,

but where can I find explanations about how to remotely connect using ODBC and DSN-less connection string.

For example, how to connect to PostgreSQL server from remote computer using MS Access and DSN-less connection string ?

Since now, I successfully conected from MS Access using DSN-less connection string but from the same machine. What if server is on a remote computer ? Is there any guide?

 

Thanks in advance,

 

Zlatko

 

Re: [GENERAL] Remopte connection to POstgreSQL via ODBC

From
Poul Møller Hansen
Date:
Google is your friend, follow this http://archives.postgresql.org/pgsql-odbc/2004-02/msg00029.php

Poul


Zlatko Matić wrote:
Hello.
 
I just read all about TCP/IP, pg_hba.conf, listen_adresses and similar topics regarding remote TCP/IP connections,
but where can I find explanations about how to remotely connect using ODBC and DSN-less connection string.
For example, how to connect to PostgreSQL server from remote computer using MS Access and DSN-less connection string ?
Since now, I successfully conected from MS Access using DSN-less connection string but from the same machine. What if server is on a remote computer ? Is there any guide?
 
Thanks in advance,
 
Zlatko