Post reply

Need Help ASAP!

  • September 6, 2005 at 2:19 pm

    #88955

    I get this error:

    "This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected."

    I don't even use SQL Server...why would this be happening all of a sudden?

    Thanks,

     

    Gary

  • September 6, 2005 at 2:20 pm

    #587924

    Are you using MSDE?

  • September 6, 2005 at 2:25 pm

    #587927

    I don't think so.  Like I said, I've only used MS Access.  My server all of a sudden is giving me this error.

    I have a hosting account through Interland and generally use a Plesk interface....but I do have the ability to log on via terminal services.

    Any ideas here?

  • September 6, 2005 at 2:28 pm

    #587930

    I don't see Access in your original post. It sounds like an MSDE error. Sorry I can't help any more. Sounds like you need to contact Interland.

  • September 6, 2005 at 2:35 pm

    #587934

    Is it possible that some tables are linked to msde??

  • September 6, 2005 at 2:37 pm

    #587935

    Nope, I do a call to the MS Access database only....one table lives there:

     

    var oConn = Server.CreateObject("ADODB.Connection")

    MdbFilePath = Server.MapPath("database/pornstar.mdb");

    oConn.Open("Driver={Microsoft Access Driver (*.mdb)}; DBQ=" + MdbFilePath + ";");

  • September 6, 2005 at 2:40 pm

    #587936

    Now it became interesting. Are you sure it's not possible that the access db has LINKED TABLES?

  • September 6, 2005 at 3:19 pm

    #587941

    I reckon people would be more keen to help if you posted a copy of pornstar.mdb

    Under what circumstances does the error message appear? Are you accessing table data, running queries etc?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • September 7, 2005 at 5:15 am

    #588037

    Haha!  No doubt!  It happens when I'm trying to do an insert into the database....using asp (jscript).

    Nothing fancy going on here...it's a brand new site I'm working on...same server as all my other sites, same code pulled off an existing site.

    Query works, connection strings are correct...out of the blue...this lousy error message....it's BS I tell you!

  • September 7, 2005 at 5:53 am

    #588043

    Sounds like Access is using the SQL Server Desktop Engine instead of JET, which limits the number or running queries to 8. See this article:

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_0ciq.asp

    and this

    http://techrepublic.com.com/5100-10878_11-5031981.html

Viewing 10 posts - 1 through 9 (of 9 total)

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