ISsue while connecting the SQL Server db from ASP page -

  • Hi,

    Hi,

    I am trying to connect to database (SQL server 2000) using

    ASP which is running on IIS server.

    I am getting the following error when I run asp page.

    Error Type:

    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server

    does not exist or access denied.

    error

    HTTP 500.100 - Internal Server Error - ASP error

    Internet Information Services

    --------------------------------------------------------------------------------

    Technical Information (for support personnel)

    Error Type:

    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

    Browser Type:

    Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727)

    Pls suggest the solution

    Thanks inadvance

  • Can you post the connection string you are using and the code that tries to connect?

  • You probably mistyped your dbname or password. Have another look at that connection string as that is usually the cause of the problem.

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • I have the same problem. I can't connect to my database that resides on Windows 2008 - IIS 7.0 with a connection string. I get the same error. I can connect with mySQL workbench without any problem though. According to my servers (DiscountASP.net) database manager page my connection string is "server=mysql501.discountasp.net; database=MYSQL5_802000_fhs; uid=djgoodys; pwd=******"

    Is there something missing?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply