From: b gonzales <bgonzales@uswest.net>
To: pgsql-interfaces@postgresql.org
Subject: Problem with PostgreSQL ODBC driver 6.40.0006
Date: Sun, 6 Jun 1999 23:14:25 -0700
Message-ID: <004101beb0ac$fe9fc6a0$5354e1cf@Gonzales> (raw)
Hi all,
Somehow, I cannot connect to Postgres 6.3 running on Red Hat 5.2. I did setup the i parameter and tested it with pgaccess. I am trying to use ADO 2.0 to retrieve a recordset from Postgres and I'm using the Postgres ODBC driver from Insight ver 6.40.0006. I am getting the error message "Runtime error 3706" and "ADO could not find the specied driver". I am using a Windows 98 OS with VB 6.0 as front end development and MS ADO 2.0 as data access.
Here's the summary of the ODBC DSN
1) Database = demo1 /* My sample database
2) Server = 192.168.10.3 /* The IP address of Postgres database
3) User Name = User1 /* Valid user on Postgres
4) Password = User1
5) Port 5432
6) Data Source Name = PostgreSQL
Then here's the ADO 2.0 code
1. Dim adoConn as ADODB.Connection
2. Dim adoRS as ADODB.Recordset
3.
4. set adoConn = new ADODB.Connection
5. adoConn.Open "PostgreSQL"
6.
7. adoRS.Open SQL, adoConn
8. 'More code goes here
Error is in line 5 :
"Runtime error 3706" and "ADO could not find the specied driver"
Thank you very much.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: bgonzales@uswest.net
Subject: Re: Problem with PostgreSQL ODBC driver 6.40.0006
In-Reply-To: <004101beb0ac$fe9fc6a0$5354e1cf@Gonzales>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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