Received: from ptldpop1.ptld.uswest.net (ptldpop1.ptld.uswest.net [198.36.160.1]) by hub.org (8.9.3/8.9.3) with SMTP id BAA10808 for ; Mon, 7 Jun 1999 01:57:59 -0400 (EDT) (envelope-from bgonzales@uswest.net) Received: (qmail 13655 invoked by alias); 7 Jun 1999 05:57:55 -0000 Delivered-To: fixup-pgsql-interfaces@postgresql.org@fixme Received: (qmail 13636 invoked by uid 0); 7 Jun 1999 05:57:54 -0000 Received: from dialupd83.ptld.uswest.net (HELO Gonzales) (207.225.84.83) by ptldpop1.ptld.uswest.net with SMTP; 7 Jun 1999 05:57:54 -0000 Message-ID: <004101beb0ac$fe9fc6a0$5354e1cf@Gonzales> From: "b gonzales" To: Subject: Problem with PostgreSQL ODBC driver 6.40.0006 Date: Sun, 6 Jun 1999 23:14:25 -0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_003E_01BEB072.5180ABE0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3155.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0 This is a multi-part message in MIME format. ------=_NextPart_000_003E_01BEB072.5180ABE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 =3D demo1 /* My sample database 2) Server =3D 192.168.10.3 /* The IP address of Postgres database 3) User Name =3D User1 /* Valid user on Postgres 4) Password =3D User1 5) Port 5432 6) Data Source Name =3D 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 =3D new ADODB.Connection 5. adoConn.Open "PostgreSQL" 6. 7. adoRS.Open SQL, adoConn 8. 'More code goes here Error is in line 5 :=20 "Runtime error 3706" and "ADO could not find the specied driver" Thank you very much. ------=_NextPart_000_003E_01BEB072.5180ABE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi all,

Somehow, I cannot connect to = Postgres 6.3=20 running on Red Hat 5.2. I did setup the i parameter and tested it with = pgaccess.=20 I am trying to use ADO 2.0 to retrieve a recordset from Postgres and I'm = using=20 the Postgres ODBC driver from Insight ver 6.40.0006. I am getting the = error=20 message "Runtime error 3706" and "ADO could not = find the=20 specied driver". I am using a Windows 98 OS with VB 6.0 as front = end=20 development and MS ADO 2.0 as data access.

Here's the summary of the ODBC = DSN

1) Database =3D demo1 /* = My sample=20 database
2) Server =3D 192.168.10.3 /* The IP = address of=20 Postgres database
3) User Name =3D User1 /* Valid user on = Postgres
4)=20 Password =3D User1
5) Port 5432
6) Data Source Name =3D=20 PostgreSQL

Then here's the ADO 2.0=20 code

1.    Dim adoConn as=20 ADODB.Connection
2.    Dim adoRS as=20 ADODB.Recordset
3.
4.    set adoConn =3D new=20 ADODB.Connection
5.    adoConn.Open=20 "PostgreSQL"
6.
7.    adoRS.Open SQL,=20 adoConn
8.    'More code goes here

Error is in = line 5 :=20

"Runtime error 3706" = and =20 "ADO could not find the specied driver"

Thank you very=20 much.

------=_NextPart_000_003E_01BEB072.5180ABE0--