From: | "b gonzales" <bgonzales(at)uswest(dot)net> |
---|---|
To: | <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | Problem with PostgreSQL ODBC driver 6.40.0006 |
Date: | 1999-06-07 06:14:25 |
Message-ID: | 004101beb0ac$fe9fc6a0$5354e1cf@Gonzales |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Heliodor Macko | 1999-06-07 11:38:48 | PG 6.5, ODBC for Win32 and BLOBs |
Previous Message | Vikrant Rathore | 1999-06-07 05:37:12 | Re: [SQL] Mail about duplicate rows |