> > 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.
I believe that the ODBC drivers for SQLServer7 are actually native drivers.
Microsoft just put an ODBC interface on it. I think I heard this being
discussed at CFUN-2K.
Duane
------------------------------------------------------------------------------
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.
