1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Database connection problem

Discussion in 'Plesk for Windows - 8.x and Older' started by mircea13, Sep 16, 2005.

  1. mircea13

    mircea13 Guest

    I've made a webhosting transfer to a site. The previous cpanel isn't plesk and I have some problem. I've copied the MS Access database on httpdocs, I've made the ODBC connection and its ok, but I cannot access it.

    I receaved this error:

    500 Internal Server Error
    The server encountered an internal error or misconfiguration and was unable to complete your request.
    Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error.

    More information about this error may be available in the server error log.

    Can anybody help me, please?
  2. vekna

    vekna Guest

    If you attach error message from event log, it can help..
  3. mircea13

    mircea13 Guest

    1. Syntax error in date in inquiry expression '#16.09.2005#'

    2. Operation must use an updatable inquiry

    I hope you understand, I've made a translation from German text.
  4. mircea13

    mircea13 Guest

    The procedure is not certified for a closed object.

    This is what I receaved when I try to open my administration interface, where I can see the data from database but I cannot modify them.
  5. mircea13

    mircea13 Guest

    I've noticed that through my interface panel, btw witch works, I can delete, add or edit records in some tables. But in other tables nothing happens and in other, if I want to add, it gives me an error (500-internal server error), but if I want to delete, it works.

    On my previous server, it works just fine.

    Is someone dealing with this? Can anybody help me?
  6. Gris@

    Gris@ Guest

    It seems that datetime format is wrong.

  7. mircea13

    mircea13 Guest

    But it works fine on the previous server.
  8. mircea13

    mircea13 Guest

    Ok Gris, like you said, it seems that datetime format is wrong. My provider gives me mssql space and ms access support (my database is in access). Maybe I must write the datetime in another sintax :confused:

    This is my code:
    dd = dateserial (Request.Form("txtAn"),Request.Form("txtLuna"),Request.Form("txtZi"))

    conn.Execute "Insert Into T_CURR (usdVal, eurVal, addDate) VALUES (" & Request.Form("txtUSD") & "," & Request.Form("txtEUR") & ",#" & dd & "#)"

    And I receive the following error:
    Syntax error in date in inquiry expression '#16.09.2005#'