Databases - Access

Troubleshooting - access DSNs

There are several different problems users may experience when using Access Databases.

1. If you receive the error: "No Data Source Name" the code is trying to call a database that does not have a DSN connection. In this case, try the following:
   
   • If a DSN has been setup, please confirm that the DSN called in the code corresponds to the DSN that was sent to you.

   If you have tried these two suggestions, and continue to recieve the error, please contact Technical Support.
   
   

2. If you receive the error: "Database is Read Only" or "Couldn't Lock File" the database permissions are set incorrectly. This could be the result of several different problems.
   
   • FrontPage users occasionally experience this problem when uploading new or modified databases with FrontPage. FrontPage changes the configuration of the database when it is uploaded, so that information can be read from, but not written to the database.
     
   • The database original database resides in the root directory or a directory not specifically for databases. (For best results, create a folder specifically for databases. This will allow manual uploading or replacement of an existing database without configuration changes by Technical Support.)

   
   In either case, please contact our support staff and we will make the necessary modifications.

Add a DSN

Database use is included with our hosting services. If database access is not included in your hosting package, please visit http://www.hostsiam.com/support/dsn.asp

ODBC

In order to have an ODBC database set up for you, submit a service request via http://www.hostsiam.com/support/dsn.asp

.  The support team needs the following information to set up the connection for you:

• Your site's IP address or domain name
• The physical path of the .mdb file relative to your content root, for example: /www123_4/db/db1.mdb
• The desired name for the new DSN (Data Source Name): The DSN is a connection made by the ODBC server to a specified database. This connection is then assigned a name which can be called by ASP (Active Server Pages), Cold Fusion, or other programming/scripting languages to manipulate the database.

Other notes

• Try not to use generic names for your database and DSN, such as Database.mdb
• If you do not specify a DSN, one will be assigned to you.
• You must have the .mdb file uploaded for the DSN creation to take place.

SQL

In order to have an SQL database set up for you, submit a request via email to support@hostsiam.com. The support team needs the following information to set up the connection for you:

Login: This is your www123_4* administrator account login.
Pass: This is your pre-assigned password which corresponds to your www123_4* login.
Space: Size of the database to be upsized to the SQL server.
Name of the DSN: The DSN (Data Source Name) is a connection the ODBC server makes to a specified database. This connection can then be called by programs written in ASP, Cold Fusion, etc. via the assigned name.

Upsizing to SQL

The Situation: What is the process to migrate tables (schema and contents) from Microsoft Access to Microsoft SQL Server?

Suggested Action: It's easiest to just export the Access database into SQL Server via Access 2000. A copy of the original Access database is all the tech support staff needs to facilitate the change-over.