BUG #14386: Run-time error '3018' with psqlODBC Driver using VB6 and DAO

From: mg(at)bts(dot)co(dot)uk
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14386: Run-time error '3018' with psqlODBC Driver using VB6 and DAO
Date: 2016-10-20 09:20:24
Message-ID: 20161020092024.1413.6505@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14386
Logged by: Mick Griffin
Email address: mg(at)bts(dot)co(dot)uk
PostgreSQL version: 9.5.4
Operating system: ubuntu Linux (64)
Description:

I have installed
https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_09_05_0400-x86.zip
on a Windows 7 Professional (SP1) operating system.I created ODBC DSNs for
both PostgreSQL ANSI and PostgreSQL UNICODE.
I ran a simple test to select data from a table.

Private Sub Form_Load()
Dim str As String
Dim db As Database
Set db = OpenDatabase("", True, False,
"ODBC;DATABASE=MyDatabase;UID=MyUserID;PWD=MyPassword;DSN=PostgreSQL35W")

Dim rs As DAO.Recordset
Set rs = db.OpenRecordset("select * from configitems")

rs.MoveFirst
While Not rs.EOF
str = " " & rs![_key] & " , " & rs![_value] & ", " & rs![_attribute]
Debug.Print "DATA:" & str
rs.MoveNext
Wend

rs.Close

End Sub

The OpenRecordset throws error
Run-time error '3018' Could not find field.

I am using the Microsoft DAO 3.6 Object Library.
If I run the same select and psqlodbc drivers with VB6 and ADO it works
OK.

If I run the DAO test with driver "Devart ODBC Driver for PostgreSQL" it
works OK.

VB6 is Microsoft Visual Basic 6.0(SP6).

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-10-20 13:23:27 Re: BUG #14384: pg_dump uses excessive amounts of memory for LOBs
Previous Message Strahinja Kustudić 2016-10-20 09:12:48 Re: BUG #14385: Operator IS changed priority in 9.5