-----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
