>
> Is there some imposed limit which would cause CF accessing an
> MSSQL7 db thru
> ODBC? I am trying to submit 64k + of data via a post but the data
> is getting
> truncated. Has anyone else ever seen this? Is there a work around or fix?
>
Duane,
Something that came up in discusion on the UK CFUG Dev List that you might
be interested in....
We were dicussion ODBC vs OLE DSNs for Access databases.
Allaire recommends that you use OLE as the connection to databases for
robustness. However, thats not what I'm trying to say. It came up that OLE
is actually the native database connection method for SQL7 and therefore
Access2000 (as it uses the SQL7 db engine).
Whether using OLE instead of ODBC will solve your data size problem or not I
don't (having never really used OLE), but it will help with robustness and
performance.
Regards
Stephen
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
