SQL Connection

Discussion in 'Databases' started by f caruso, Feb 7, 2013.

  1. 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
     
    Last edited by a moderator: Oct 14, 2015
  2. Elshadriel

    Elshadriel Winhost Staff

    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.
     
  3. 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
     
  4. Elshadriel

    Elshadriel Winhost Staff

Share This Page