[thelist] ASP RecordSet weirdness (FIXED)

[Tab Alleman]

In case any of you were interested, I fixed this problem by changing the
3rd party's connection string from:

DRIVER={SQL Server}; Server=ServerName; Database=DataBaseName;
UID=UserID; PWD=Password

To:

Provider=sqloledb;Data Source=ServerName;Initial
Catalog=DataBaseName;User Id=UserID;Password=Password;

...and everything started working fine.  Why?  I don't know.


Tab Alleman wrote:
> I have a recordset open.  I'm using ASP 3, SQL2k.
> 
> When I do this in my code, everything is fine:
> 
> Str1 = rs("field1")
> Str2 = rs("field2")
> Str3 = rs("field3")
> 
> 
> All 3 fields have stuff in them, as they should.  But when I do this:
> 
> Str1 = rs("field1")
> Str3 = rs("field3")   	'order of 2 & 3 reversed
> Str2 = rs("field2")
> 
> ...field2 is either NULL or empty.  So just for fun, I tried this:
> 
> Str2 = rs("field2")
> Str3 = rs("field3")   	'order of 1 & 2 reversed, in case "field
3" is
> a show-stopper somehow
> Str1 = rs("field1")
> 
> All 3 fields have stuff in them.
> 
> Error handling is turned off, so if there were an ASP error, it would
> throw it on the screen.  All 3 fields in the database are type
> varchar. 
> 
> My mind is boggled.  Does anybody have even a wild guess as to what
> could be going on here?