Re: [GENERAL] Using ODBC and VBA to pull data from a large object

2013-09-19 Thread Adam C Falkenberg
dam C Falkenberg , Cc: pgsql-general@postgresql.org Date: 09/19/2013 04:59 AM Subject:Re: [GENERAL] Using ODBC and VBA to pull data from a large object Sent by:pgsql-general-ow...@postgresql.org Le mardi 17 septembre 2013 à 12:25 -0400, Adam C Falkenberg a écrit : > Sorry ab

Re: [GENERAL] Using ODBC and VBA to pull data from a large object

2013-09-17 Thread Adam C Falkenberg
ite rs.Fields("data").Value rs.MoveNext Wend Adam From: Andrew Satori To: Adam C Falkenberg , Date: 09/17/2013 12:02 PM Subject:Re: [GENERAL] Using ODBC and VBA to pull data from a large object You don't say with which driver. ODBC can be a bit twitchy w

Re: [GENERAL] Using ODBC and VBA to pull data from a large object

2013-09-17 Thread Adam C Falkenberg
bytes)? Thanks again. Adam C. Falkenberg Quality Engineer Great Lakes Works Phone: (313) 749 - 3758 Cell: (313) 910 - 3195 From: Bret Stern To: Adam C Falkenberg , Cc: pgsql-general@postgresql.org Date: 09/17/2013 10:06 AM Subject:Re: [GENERAL] Using ODBC and VBA to

[GENERAL] Using ODBC and VBA to pull data from a large object

2013-09-17 Thread Adam C Falkenberg
Good Morning, I had a question about using ODBC with large objects. When I query the pg_largeobject table and return data to an ADO recordset, I can only get the first 255 bytes even though the record contains 2048 bytes of data (all the bytes after the first 255 show as 0). When I checked th