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 |
|
Gsuttie
Starting Member
14 Posts |
 Posted - 2002-01-04 : 04:28:07
|
| 'NT AUTHORITY\ANONYMOUS LOGON' type this into most search web sites which are SQL based info sites such as thgis and swynk.com and see the site fall over. Does this mean the site isnt using a stored proc ?? I do hope its not a sql string such as "select * from table"I have fell fowl of this in my early days as a developer and had a small chuckle at both (only tried 2) sites falling over.CheersGregorGreg |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-01-04 : 09:10:51
|
| Gregor,I'm confused. Typing in 'NT AUTHORITY\ANONYMOUS LOGON' (with apostraphes) generated an error because I wasn't handling apostraphes correctly. Which is ironic since I wrote an article on handling them correctly. Is this what you're referring to? If that's the case, any text with apostraphes would cause the problem.Typing in NT AUTHORITY\ANONYMOUS LOGON (without apostraphes) works just fine.I did fix the apostraphe problem though. The site does use a strored procedure to search as defined in this article. As a matter of fact you can see the lack of code to handle an apostraphe in the article. Does that make me open source? :-)I checked SWYNK and didn't see a problem there. The search just didn't return any results. I also searched their site on "NT and AUTHORITY and ANONYMOUS and LOGON" and didn't get any results back.What do you mean by falling over? That it generated an error? My site did but SWYNK didn't seem to. It just didn't return any results.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
 |
|
|
Gsuttie
Starting Member
14 Posts |
Posted - 2002-01-04 : 11:23:37
|
| Hi Graz - he site suffers from the same fate - yes very ironic.SWYNK.COM Knowledge Base--------------------------------------------------------------------------------Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'NT'. /betasite/lib.asp, line 177 Greg |
|
|
|
|
|
|
Woops I've made your site fall over