SQL Datasource truncates string values at 254 Characters 1

[kklink1]

Hey everyone,
I am using CR8 and SQL 7. I have a large data field (varchar 4000) which is being truncated in the report at 254 chars. Has anyone had any dealings with type of issue in the past? I have looked through the KB at Crystal Decisions and found this issue using the ODBC Driver, but nothing about the SQL Driver. So if anyone can help I'd greatly appreciate it.

Thanks in advance,
Kris

 

[databaseman]

Crystal does not allow any fields longer than 256 characters with any driver as far as I know. I regret that I don't know any ways around it, either.

Databaseman Database Man
Defender of Life, Liberty and the pursuit of accurate database reporting! Follow my free tek-tip adventures at:

http://www.hammerman.com/dbman.html

 

[tdz]

Im using crystal 8 connecting to an access datasource setup through ODBC. I view fields with more than 256chars in them all the time, Does anyone know why this is? Will I face problems when moving to a remote datasource thats a real sqlserver?

 

[kklink1]

tdz,
As far as I can tell the driver for ODBC sees the large fields as a memo type, whereas the SQL Driver/OLEDB sees them as text, but currently truncates it. I'm not sure if it's a limitation with the OLE DB Driver or if it's Crystal, or if it's an odd configuration issue on my end But when I switched over to the ODBC Driver it worked fine, just not the most elegant solution.

Hope this helps.

 

[bentim]

I believe the answer is that the Microsoft supplied driver for SQL has the problem. The OBDC driver does not. We use the OBDC driver and do not have the problem.