eridanix
eridanix

Reputation: 828

connect to MS Access accdb file on Windows Server 2008

In my ASP.NET application I have ftpdata folder, there is an MS Access 2010 file e.g. somename.accdb.

On my local computer (Win XP), there is no problem to connect with OleDb to this file and read write datas into and from tables.

But on server (Windows Server 2008), I cannot connect to the same file like on localhost.
Can you help me, please, where problem could be?

Upvotes: 1

Views: 1971

Answers (4)

Christopher Huemmer
Christopher Huemmer

Reputation: 1

Installing the 2010 Data Connectivity Drivers does not seem to work, what worked for me was to set the corresponding website application pool in IIS to enable 32-Bit applications.

Official Microsoft Reference:

Upvotes: 0

eridanix
eridanix

Reputation: 828

Finally, I found solution of problem.

There was not installed 2010 Data Connectivity Components on the server.

Upvotes: 1

David-W-Fenton
David-W-Fenton

Reputation: 23067

You need either direct access through the file system or SMB networking access (via a share defined on the server). If the FTP folder has an SMB share name, use that to get to it, but it's likely not shared (since it's purpose is for FTP access, not SMB access).

Upvotes: 0

citronas
citronas

Reputation: 19365

The windows user that your application pool is running in does probably not have read access to the directory/file

Upvotes: 0

Related Questions