RE: how connect visual basic to pgsql?

Hi,
I have installed ODBC support in PG-

PostgreSQL ODBC driver for Windows 95 (I'm using Win-NT-Wks 4.0)
ODBC Driver Name - PostgreSQL 6.50.0000
Company Name - Insight Distribution System
File Name - PSQLODBC.DLL

Postgres running on Linux RH-6.0 (HTTP,SAMBA services not working. Telnet
and FTP working fine.).
Other side I have VB-6.0 on Windows-NT-Workstations 4.0.
I want connectivity VB (front-end) and PG(Back-end).

When I do connectivity then error come - "Provider cannot be found. It may
not be properly installed."

Why does this error come ?
Thanks in advance
Anuj



-----Original Message-----
From: pgsql-general-owner@hub.org [mailto:pgsql-general-owner@hub.org]On
Behalf Of Philip Warner
Sent: Saturday, July 22, 2000 9:22 AM
To: Ingenieria de Sistemas; pgsql-general@hub.org
Subject: Re: [GENERAL] how connect visual basic to pgsql?


At 16:53 21/07/00 -0500, Ingenieria de Sistemas wrote:
>I am a beginner in pqsql and linux.
>I can't connect from visual basic to my pgsql server.
>When do I do telnet "host-pgsql" what is the message that have i receive
>from pgsql server if my postgres port is enabled?
>I just can read " connect to "host-pgsql", then i type anything and press
>enter .
>I read this message "connection closed by foreign host"
>what do you think about this.

You need to install ODBC drivers on your PC, and ODBC support in PG, then
use PG just like any other ODBC data source.


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.C.N. 008 659 498)             |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|
                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/