On Tue, Nov 06, 2007 at 05:48:12PM -0300, Alvaro Herrera wrote:
> FYI there's another Postgres ODBC driver that is said to have better
> performance.
>
> https://projects.commandprompt.com/public/odbcng
>
> (Yes, my company maintains it)
Are there any known issues when calling it from VB? I've got a VB (MS
Access) client that uses PG as its backend and it seems to die horribly
when doing any sort of query that returns a text column. This happens
through either DAO or ADO; though DAO gives the error "the size of a
field is too long", ADO just segfaults.
For example, the following code doesn't work for me. Looks like the
sort of thing that that should get lots of test coverage so maybe it's
something on my system.
Public Sub test()
Dim con As ADODB.Connection, rs As ADODB.Recordset
Set con = New ADODB.Connection
con.Open "DSN=badgerstudy"
Set rs = con.Execute("SELECT 1, 'foo'::TEXT, 'bar'")
While Not rs.EOF
rs.MoveNext
Wend
End Sub
Thanks,
Sam
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
