I was asking for the people who were using Access. But it would appear that
this is not the problem.
Anybody out there not using a MS database product having the same problem?
At 11:05 AM 12/4/2000 -0500, you wrote:
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>Could I just add one niggling little detail to this thread? I know
>it's a small thing, but...
>
>If ever someone's having a problem with Microsoft SQL Server 7.0 (and
>I presume 2000 is the same), asking if they're using ODBC or OLE/DB
>is rather moot.
>
>SQL Server's internal API *is* OLE/DB. Even if you're using ODBC to
>access it, the ODBC driver just translates your calls to OLE/DB and
>passes them on to the SQL Server.
>
>So... Without a doubt, OLE/DB is preferred over ODBC when using
>Microsoft SQL Server, and changing to ODBC won't make any appreciable
>difference *unless* ColdFusion OLE/DB implementation is massively
>screwed up. And I'll leave that point up for debate...
>
>
>And to think... I was planning on getting up early this morning to
>run an upgrade to CF 4.5.1 SP2... Glad I slept in instead...
>
>Best regards,
>Zac Bedell
>
>========================================
>Zachary S. Bedell,
>Chief Technology Officer,
>Adirondack Technologies, Inc.
>
> > -----Original Message-----
> > From: Nick McClure [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, December 04, 2000 10:05 AM
> > To: CF-Talk
> > Subject: RE: CF SP2 + Win2k/Memory Leaks
> >
> >
> > Have you tried using OLEDB instead of ODBC?
> >
> > >
> > >At 03:29 PM 12/4/00 +0100, you wrote:
> > > >I had this issue on an Access 2000/CFserver 4.5.1sp1
> > machine running MDAC
> > > >2.6. Reverting to MDAC 2.5.1 solved the issue for us there.
> > > >
> > > >We're having the same problem on a NT4,sp5 SQL7.0 setup.
> > > >
> > > >A little experimenting this morning shows that running a
> > query with a
> > > >large result set moved memory to swap file and just hung there.
> > > >I'm beginning to suspect that there are memory allocation
> > issues with CF4.51.
> > > >Perhaps the solution is to turn off all caching.
> > > >
> > > >It hardly seems appropriate that one needs to kill key
> > advantages on CF in
> > > >order to maintain some measure of stability.
>
>Amen, brother! Preach it!..... *grin*
>
>
>-----BEGIN PGP SIGNATURE-----
>Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
>
>iQA/AwUBOivAxKvhLS1aWPxeEQLpgACbBo2TQ/vtWpH6NUk6HVzSm1KjuMcAnRQZ
>VKdzQ+89/Jc37avasUI6n7uU
>=qKwO
>-----END PGP SIGNATURE-----
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
