XPost: Problem with IIS 7 and DB's

Discussion in 'ASP General' started by Jan K. van Dalen, Aug 8, 2007.

  1. Ok, I wrote test (ASP, ASP.Net & PHP) all of them hitting the same database.

    This is the first time I try to connect to a DB under Vista/II7 and it seems
    that I'm missing setting some type of security but don't know what.

    When test the ODBC connection everything works fine, when executed from
    inside ASP, I get this error:

    Unable to establish connection to database.
    Error information:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Sybase][ODBC Driver][Adaptive Server Anywhere]Unable to start database
    server
    Other possible cause of this problem:
    The database cannot be opened, most likely due to incorrect connection
    settings or insufficient security set on your database folder or file.
    For more details please refer to
    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306518


    The link does not help me. I have seem many reference to IIS 7 having lots
    of problems connecting with DB's (BTW, I'm using Sybase ASA 9.x)

    Any help will be appreciated.
     
    Jan K. van Dalen, Aug 8, 2007
    #1
    1. Advertising

  2. Jan K. van Dalen

    David Wang Guest

    On Aug 7, 9:32 pm, "Jan K. van Dalen" <>
    wrote:
    > Ok, I wrote test (ASP, ASP.Net & PHP) all of them hitting the same database.
    >
    > This is the first time I try to connect to a DB under Vista/II7 and it seems
    > that I'm missing setting some type of security but don't know what.
    >
    > When test the ODBC connection everything works fine, when executed from
    > inside ASP, I get this error:
    >
    > Unable to establish connection to database.
    > Error information:
    > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    > [Sybase][ODBC Driver][Adaptive Server Anywhere]Unable to start database
    > server
    > Other possible cause of this problem:
    > The database cannot be opened, most likely due to incorrect connection
    > settings or insufficient security set on your database folder or file.
    > For more details please refer tohttp://support.microsoft.com/default.aspx?scid=kb;en-us;Q306518
    >
    > The link does not help me. I have seem many reference to IIS 7 having lots
    > of problems connecting with DB's (BTW, I'm using Sybase ASA 9.x)
    >
    > Any help will be appreciated.




    IIS does not connect with databases. It runs applications that connect
    with databases.

    I suspect you are seeing a variant of this:
    http://blogs.iis.net/bills/archive/...derstanding-temporary-directory-failures.aspx

    It really illustrates a hidden weakness within the database being
    used.


    //David
    http://w3-4u.blogspot.com
    http://blogs.msdn.com/David.Wang
    //
     
    David Wang, Aug 8, 2007
    #2
    1. Advertising

  3. David, first, thanks.

    I was able to get it working doing in part what the link recomended but also
    had to turn on ASP.Net impersonation and set it to my own user/password.


    "David Wang" <> wrote in message
    news:...
    > On Aug 7, 9:32 pm, "Jan K. van Dalen" <>
    > wrote:
    >> Ok, I wrote test (ASP, ASP.Net & PHP) all of them hitting the same
    >> database.
    >>
    >> This is the first time I try to connect to a DB under Vista/II7 and it
    >> seems
    >> that I'm missing setting some type of security but don't know what.
    >>
    >> When test the ODBC connection everything works fine, when executed from
    >> inside ASP, I get this error:
    >>
    >> Unable to establish connection to database.
    >> Error information:
    >> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    >> [Sybase][ODBC Driver][Adaptive Server Anywhere]Unable to start database
    >> server
    >> Other possible cause of this problem:
    >> The database cannot be opened, most likely due to incorrect connection
    >> settings or insufficient security set on your database folder or file.
    >> For more details please refer
    >> tohttp://support.microsoft.com/default.aspx?scid=kb;en-us;Q306518
    >>
    >> The link does not help me. I have seem many reference to IIS 7 having
    >> lots
    >> of problems connecting with DB's (BTW, I'm using Sybase ASA 9.x)
    >>
    >> Any help will be appreciated.

    >
    >
    >
    > IIS does not connect with databases. It runs applications that connect
    > with databases.
    >
    > I suspect you are seeing a variant of this:
    > http://blogs.iis.net/bills/archive/...derstanding-temporary-directory-failures.aspx
    >
    > It really illustrates a hidden weakness within the database being
    > used.
    >
    >
    > //David
    > http://w3-4u.blogspot.com
    > http://blogs.msdn.com/David.Wang
    > //
    >
     
    Jan K. van Dalen, Aug 8, 2007
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Chris
    Replies:
    3
    Views:
    1,342
    Chris
    Sep 10, 2003
  2. Chris

    Embedded Perl or Python (XPost)

    Chris, Sep 5, 2003, in forum: Python
    Replies:
    9
    Views:
    382
    Chris
    Sep 10, 2003
  3. stefanogaburri
    Replies:
    12
    Views:
    759
    jsimha_makineni
    Feb 8, 2004
  4. Belgian
    Replies:
    0
    Views:
    384
    Belgian
    Feb 7, 2006
  5. Il Prof

    [XPOST] [C] Access speed: pointers Vs array

    Il Prof, Aug 5, 2004, in forum: C Programming
    Replies:
    4
    Views:
    375
    David Schwartz
    Aug 7, 2004
Loading...

Share This Page