Hey guys, I'm getting this weird DB error in an ASP application:
From looking on the web, it looks like this has to do with authorization if you use an NT account to access the database, but I'm using an SQL account and my other 20-30 SQL connections (which use the EXACT same connection string) run without a problem. The only thing that I could think of is that maybe my OLEDB drivers aren't up to date on my web server (they're 2.5 SP2, and 2.6 SP2 Refresh is the version that matches my SQL Server 2000 SP2 install). I'm going to try updating them, but does anyone else have any clue why this one connection won't work?
Microsoft OLE DB Provider for SQL Server (0x80004005)