Making the connection to the database.
The standard server connection string
is for a DNS connection which needs to be set up in the registry of each computer that is to run your database. Clearly this is impossible for a database on CD. You need to set up a non-DNS connection string as follows.
To connect to the database, use the Microsoft Jet provider connection string. The path to the database should be detemined using the Server.MapPath method - rather than an absolute path - so that the path is correct for whatever CD drive is being used.
We recommend that all versions of MS-ACCESS database be converted to MS-ACCESS 2000. If you need to create an earlier database version, this can be done by adding the Engine Type to the connection string. ACCESS 97 is Engine Type=4, ACCESS 2000 is Engine Type=5.
If database is protected by a password, the password should be added to the connection string.
Databases should not be password protected using the Dynamic-CD-Wizard - this would make them unreadable by the ADODB component. To protect databases, give them a database password using MS-ACCESS and then connect to them as above. The dbPwd itself can be hidden in an encrypted ASP file.
Managing source code for the Internet and for Dynamic-CD
© Copyright 2000-2007 PHD Computer Consultants Ltd