Re: Help: Data in LONG column truncated to 100 chars.

I came across the same problem using ADO from VBScript with the Oracle for OLEDB provider. It does seem strange that the behaviour occurs only when tables are joined.

I have a couple of solutions you can try:

1. In your ORAOLEDB.Oracle provider connection string, add a ChunkSize parameter. e.g. ChunkSize=2147483647 will return up to 2GB.
2. Use the Microsoft ODBC driver for Oracle (provider=MSDAORA)

I hope this sorts out your problem

--
Posted via http://dbforums.com