• Dear Pleskians! The Plesk Forum will be undergoing scheduled maintenance on Monday, 7th of July, at 9:00 AM UTC. The expected maintenance window is 2 hours.
    Thank you in advance for your patience and understanding on the matter.

Access ODBC DSN Only Works Once

M

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?
 
Hi,

Make sure what database files permissions was inherited from directory.
 
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 ??
 
Back
Top