The setting method of Access database for Godaddy virtual host
the virtual host abroad is cheap, make a Godaddy virtual host, 5G space, 250G month flow is less than 400 a year. But it is a bit troublesome to set up, otherwise there will be a problem of failing to connect the Access database through ADO connection, or the Access database can not be written. It took a long time to get it done, and record it.
first log in to the Godaddy management background, enter the my hosting account virtual host management page, and enter the Access database settings page from the "Databases" column. At this time, you can see that the database has not been activated. You must first click on the Enable access support link to enable the database.
when the access database is enabled, the system automatically generates a folder named access_db in the user's space, which has read and write rights, and the MDB database stored in the directory can not be downloaded. At this point, if you use FTP client software such as CuteFTP and FlashFXP to log in, you can see that there is a access_db directory in the space. But don't rush to upload your database. After
enable the database, you can see that it is temporarily in pending state, and it will take effect in about 5-20 minutes. After the entry into force, the access database settings page can see the word "Current Access Support: Enabled", which is enabled successfully.
next, in the "Access DSN's" below, create a new DSN by "create new DSN", the database name is your website's database name, username and password can be filled out at will. After creation, it will take 5-20 minutes to take effect. If you can't, wait a few hours more.
well, the backstage has been set up. At this point, you can upload your database, which must be MDB as an extension, to the access_db directory that you just generated from the system and set up your ASP/ADO database connection file.
also, if you browse your own web page, you find that the Chinese language in the Access database displays a mess, and you can use the database utility in the Microsoft Access 2000 (or higher version) to convert the database to an early Access database version. Or add the following code to the ASP source file of the website:
[code].lt;% @ CODEPAGE =.Quot; 936.quot;%.gt; [/code]
for Godaddy virtual host FSO read / write permissions / > default, all folders uploaded through the default, need to be in the post. The platform is set up.
enter the virtual host control panel of the my hosting account, enter the Directory management panel from the "content" column on the left, and create the folder by the Create Directory button under the "Custom Directories" option. . After add is finished, it is in the "Pending Setup" state. After that, the folder has FSO read-write permissions.