Thread: Problem with PostgreSQL ODBC driver 6.40.0006
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
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 :
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.