I'm using Excel. I needed to set the MAXVARCHARSIZE parameter in the connection string to take care of my issue (MAXVARCHARSIZE=2048 for me). That allowed the defined size of the field to equal the actual size. Thanks everyone for your help!
Adam
From: Vincent Veyron <vv.lists@wanadoo.fr> To: Adam C Falkenberg <ACFalkenberg@uss.com>, 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-owner@postgresql.org
Le mardi 17 septembre 2013 à 12:25 -0400, Adam C Falkenberg a écrit : > Sorry about that. Here's the driver information and some code.
> Driver Name: PostgreSQL ANSI > Version: 9.02.01.00 > > constr = "Driver={PostgreSQL ANSI}; Server=servername; Port=5432; > Database=databasename; Uid=username; Pwd=password;" > With conn > .ConnectionString = (constr) > .Open > End With > > SQL = "SELECT data FROM pg_largeobject WHERE loid = " & id & " ORDER > BY pageno" > rs.Open SQL, conn > > stream.Type = adTypeBinary > stream.Open > > ' Loop through the recordset and write the binary data to the stream > While Not rs.EOF > stream.Write rs.Fields("data").Value > rs.MoveNext > Wend
You don't say where you use that recordset (Excel, Access?)
A google search will return several discussions about this problem; here is an example :
