Re: Strange Recordset/Query Problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dave (im_at_not.telling)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 13:54:24 -0500

> Are you using ODBC to connect? If so, switch to te native SQL Server OLEDB
> provider (SQLOLEDB). See www.able-consulting.com/ado_conn.htm for connection
> string examples. There was a bug in the ODBC driver that causes data to be
> "lost" unless it is immediately saved to a variable. That might be what's
> going on here.
>
> Bob Barrows

BAM! That got it. It's working perfectly now. I was using the
connect string that was given to me by the hosting company,
so that's why I was using MSDASQL, but changing it to SQLOLEDB
fixed it all.

Thanks a million Bob! And thanks to everyone who bothered to
slog through that code and give suggestions!

 - Dave

P.S. Sorry Bob...I replied at first via e-mail instead of the
group.

Relevant Pages