1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Access ODBC DSN Only Works Once

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

  1. mikelegg

    mikelegg Guest

    I have a number of users trying to use OBDC DSNs to read/write to Access databases. When they set the DSN up in Plesk and test it it connects successfully. But in real world situations the database can only be read once and then it reports an "Unspecified Error -2147467259". I've given IUSR_domainname full permissions on the folder which the database in in so that the the ldb file will be able to be deleted.
    But sometimes I can even see the ldb file sitting in the folder.

    Does anyone have any suggestions?
  2. Mr.Incredible

    Mr.Incredible Guest


    Make sure what database files permissions was inherited from directory.
  3. mikelegg

    mikelegg Guest

    Yes, I've done that.

    Basically, I'm going to tell all new clients that we don't support Access DSNs and that they should use a direct connection to the file using the Jet driver.

    It makes wonder what Plesk is actually testing when it reports that the DSN is working ??