On 9/18/00, Paul Johnston penned:
>Replying to my own post to explain it a bit better.
>
>We are running several Cold Fusion 4.5 servers from one MS SQL Server 7.
>
>On all but the one we want it to work on, the error below is occurring. The
>error is that the WDDX packet is incomplete (ie it is not an XML Packet).
>What happens is that I insert a wddx packet into the database and then
>retrieve it from the database on the next page (the reason for this is that
>we can't use cookies, and we need some way of tracking a person through the
>site, so a simple ID is created, and follows the person through the site).
>It definitely goes completely into the database (I've checked it). However,
>when I retrieve the packet on the next page, only 255 characters are
>retrieved from the database, which means that any wddx packet of larger than
>255 characters is not complete when returned.
I found this in the Knowledge base. Have you checked to see that you
have the lastest MDAC on the machines giving you problems?
In ColdFusion Server for Windows 95/98/NT, when
CFQUERYing an ODBC datasource that contains
a field with more than 255 characters in it, only the
first 255 characters are returned.
This problem is caused by an outdated version of Microsoft Data Access
Components (MDAC). MDAC is the ODBC subsystem as well as the ODBC
drivers for all of Microsoft database products (Microsoft SQL Server, Access,
FoxPro, etc.). ColdFusion communicates to databases using this subsystem.
Downloading and installing the latest MDAC from Microsoft fixes the
problem.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------
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.
