HTTP 500 error Provider error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. /WebShopOnline/include/dbcommon.asp, line 49 my dbcommon.asp file line 49 is an open statement. can someone verify the following and tell me what may be missing please. tech support has not been a help.. strconnection = "Provider =SQLOLEDB; Data Source=tcp:s09.Winhost.com;Initial Catalog=DB_53899_webshopdb;User ID=DB_53899_webshopdb_user;Password=******;Integrated Security=False;" I am assuming the only change I need is changing the ****** to my password. Anyone have a similar issue connecting using ASP
Yes, at least make sure the ****** is your actual password. It's ok to mask it though on the forums. If you get another error, then post it here.
HTTP error 500 The only error is the one stating http error 500 when I change the internet options to view friendly errors it reports connection error line 49 . see below http://www.tekwebonline.com/WebShopOnline/menu.asp this will display the http error. the actual error under this is : Provider error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. /WebShopOnline/include/dbcommon.asp, line 49 Same error on http://www.tekwebonline.com/WebShopOnline/dbo_Companies__view.asp th line 49 in dbcommon only has a line to open the connection
I don't see the error, but you might want to take a look a this link for a solution: http://forums.iis.net/t/1150597.aspx/1