I'm trying to read 12K records from a pipe delimited text file. There are 34 columns in the file. one of which is proxyAddresses.

The probelm:

Some proxyAddresses value extend beyong 256 characters. So when the data is returned in my ADODB.Recordset, i only get to see the first 256.

Here are some details.

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strRootDir & "\;" & _
"Extended Properties=""text;HDR=Yes;FMT=Delimited;"";"

I''ve also used the Schema.ini file with the above connection string and the particular column set as follows:

Col1=proxyAddresses LongChar

also tried...

Col1=proxyAddresses Text 1024

But when i check on the field size I get this:

TYPE: 202

Is there anyway to extend that default 255/256 to 1024

Any help would be greately appreciated.


Re: 256 Char limit on ADO Recordset Field


I had to dig deep for this one...

I can't find it documented anywhere..... Is it a Provider taboo Well that's about to change...

In the scripting guys do mention a blurb about " Make sure you set the HDR=NO" in the connection string when using the Schema.ini, albeit they don't tell you why..

So that's it...

changed: three characters in my code... can it be any simpler

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strRootDir & "\;" & _
"Extended Properties=""text;HDR=NO;FMT=Delimited;"";"

and voila! Now the provider initializes the columns using the datatypes and widths defined in the schema.ini

Thanks for tuning in...