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(at)hub(dot)org [mailto:pgsql-general-owner(at)hub(dot)org]On
Behalf Of Philip Warner
Sent: Saturday, July 22, 2000 9:22 AM
To: Ingenieria de Sistemas; pgsql-general(at)hub(dot)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 |/