Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stoland
Starting Member
5 Posts |
 Posted - 2007-07-03 : 09:46:00
|
I have an ASP.NET/ADO.NET page i wrote. It was based off of the development database during most development, and it switched over seamlessly to the production database.Except for yesterday, when i went back to edit the page. It simply stopped returning results on my queries. To see if it was caused by bad values being passed to the sqldatasource, i tried it in the "Configure Data Source..." window, and it returns zero rows. When passing all of the exact same parameters to the same procedure in the same DB engine, even using the same login information, it works.Just not in my ADO.NET app anymore...Can anyone tell me what the hell could be going on here, please? I already rebuilt the page from an older version this morning, being very minimal on changes, and the last thing i changed before it stopped working was the connection string... *BUT* I have triple-checked that against the canon string we have always used in every working copy.I'm losing a lot of hair over this  . Any help would be greatly appreciated.Thanks in advancestoland |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
...Works in Management Studio, Not in .NET anymore