[thelist] ASP RecordSet weirdness (FIXED)
Tab Alleman
Tab.Alleman at MetroGuide.com
Tue Apr 6 15:23:09 CDT 2004
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?
More information about the thelist
mailing list