请问lunaroages上window plan的ACCESS数据库需要设置么?
|
|
昨天买的window空间,ASP没有问题,但是好像一需要读到数据库就出错了。。。发信问客服,说是需要设置一下ODBC。(我把网站放在国内的空间是完全没有问题的) 下面的信是客服回的,但我在控制界面就是找不到那个设置ODBC的按钮。请问大家有用到access数据库的朋友怎么设置的呢?
To use a Microsoft Access Database (.mdb file):
1. You will need to create a folder within your httpdocs folder.
2. Give this folder full write permissions using the file manager. (the padlock icon next to the folder that was created will allow you to set the permissions).
Hint: If you do not set write permissions, the database can not be written to and can not generate a temp file (in the same folder as the database) required for an Access database to function correctly.
3. Once the database has been uploaded, an ODBC connection to the database must be setup to connect to it.
a. Click ODBC Settings icon in Plesk for the domain.
b. Next, click "Add New ODBC DSN".
c. Give the connection a name.
d. Select the driver as "Microsoft Access Database (.mdb)" and click ok.
e. In the field [DBQ] DB File Path *, enter the path to the database file.
e.g. C:\Inetpub\vhosts\yourdomain.com\httpdocs\folderyourcreated\database.mdb
- Replace 'yourdomain.com' with the domain name.
- Replace 'folderyourcreated', with the folder you created in step 1.
- Replace 'database.mdf' with the name of the database file.
- Leave all the other settings as default.
Next, click test connection. If the connection is successful, then click next and then ok. If the connection is unsuccessful, please ensure the server path to the database is correct. |
|
|
|
|
|
|
|
|
|
|
大漠孤狼
发表于 2007-7-25 23:59:31
|
显示全部楼层
放置access文件的文件夹要设置写入权限
国内的asp虚拟主机基本每个文件夹都有写入权限,但是这样是很不安全的。国外的安全性比较好,哪些文件夹需要写入权限要自己设置 |
|
|
|
|
|
|
|
|
|
|
colepig
发表于 2007-7-26 00:08:08
|
显示全部楼层
但是如果只是读取数据库呢?并没有写入也读不出来啊。PS版主真的好积极啊~这么晚了还在~ |
|
|
|
|
|
|
|
|
|
|
colepig
发表于 2007-7-26 00:16:53
|
显示全部楼层
|
我已经把文件夹属性设置成可以完全控制了~还是500错误~唉 |
|
|
|
|
|
|
|
|