Hello,
This query works for me on Access 2003. Which versions of Access and
ODBCng you have?
We can communicate via odbcng@lists.commandprompt.com
<mailto:odbcng@lists.commandprompt.com>. I'll try to help you with any
problems.
Sam Mason wrote:
> 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
>
Thanks,
Andrei.