一杯茶

国外asp空间一般都是plesk面板，有些支持access数据库，使用比较方便;
但有些需要设置 odbc dsn访问才能使用ms access，否则容易出现500 Internal Server Error，

asp空间支持access数据库的设置方法如下：

How to use a Microsoft Access Database (.mdf file) on Plesk?

Follow these steps:

To use a Microsoft Access Database (.mdf file), you will need to create a folder in your web space (inside the httpdocs folder) and give this folder full write permissions using the file manager in your Plesk control panel (click the padlock icon next to the folder you have created to set the permissions).

Once the database has been uploaded, you may wish to setup an ODBC connection to the database for easier connection.

Click the ODBC icon in your Plesk control panel for the domain. Next, click “Add New ODBC DNS”. Give the connection a name. Select the driver as “Microsoft Access Database (.mdf)” and click ok. In the field [DBQ] DB File Path *, enter the server path to your database file you have uploaded to your web space e.g. C:\Inetpub\vhosts\yourdomain.com\httpdocs\folderyourcreated\database.mdf – Replace ‘yourdomain.com’ with your domain name. Replace ‘folderyourcreated’, with the folder you created in step 1. Replace ‘database.mdf’ with the name of your database file.

Leave all the other settings as default. Next, click test connection. It connect is successful, then click next and then ok. If the connection is unsuccessful, please ensure the server path to the database is correct.

If you want to connect to the database using your scripts, you can use:

strConnString = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\vhosts\yourdomain.com\httpdocs\folderyourcreated\database.mdf” ‘## MS Access 2000