Installation problems

Cannot update. Database or object is read-only.
When I try and make changes to times or users I get the message 'Cannot update. Database or object is read-only.'
Show Answer
This message is most likely to appear if you are using DbNetTime with an Access database. It is caused by the permissions on the file not allowing the file to be written to.

To correct this problem do the following;

1. Select the file using Windows Explorer.
2. Right-click on the file and select Properties.
3. Select the Security tab.
4. Assign "Full Control" to "Everyone" and click "OK".

If the propblem persits, set the permissions on the folder that contains the Access file, following the steps above.

Hide Answer


I don't have a copy of SQL Server
I don't have a copy of SQL Server. How can I evaluate the application?
Show Answer
If your Server/PC has .Net Framework 2.0+ installed then we would recommend installing Sql Server 2005 Express

http://msdn2.microsoft.com/en-us/express/aa718378.aspx

You can also get a graphical management tool for Sql Server 2005 Express from this link;

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en


If your Server/PC does not have.Net Framework 2.0+ (and you do not want to install it) then we recommend installing MSDE 2000 (SQL Server 2000)

http://www.microsoft.com/sql/prodinfo/previousversions/msde/prodinfo.mspx

For information on how to install MSDE 2000 see the following link:

http://aspnet101.com/aspnet101/tutorials.aspx?id=44

One of the limitations of MSDE is that it does not include any administration tools which although not required for the initial install may prove useful for functions such as backups.

There are a number of administration tools available from various vendors, a list of which can be found here:

http://www.microsoft.com/sql/partners/msde.mspx



Hide Answer


Manually Installing DbNetTime
Can I install DbNetTime without using the install.hta application?
Show Answer
In the first instance we would always recommend that DbNetTime is installed using the installation application (install.hta).

If you would like to manually install DbNetTime on your server you should do the following;

1. Extract the contents of the zip file to your specified directory.
2. Run the following files by copying and pasting their content in to SQL Query Analyser;
- {installationFolder}/data/DbNetTimeSchema.sql
- {installationFolder}/data/DbNetTimeData.sql

Note: The DbNetTimeSchema.sql must be run before DbNetTimeData.sql.

3. Create an IIS virtual folder for DbNetTime. Ensure than the folder is running as an application.

4. Add a database connection string to the ‘DbNetTimeDb’ key of the ‘appSettings’ node in the web.config file. The web.config file can be found in the DbNetTime root installation folder.

More information about ADO and ADO.Net database connection strings can be found here;

http://www.carlprothman.net/Default.aspx?tabid=81

5. Set the login authentication mode for DbNetTime. By Default this is set to ‘Forms’ ie each time a user logs in to DbNetTime they will be required to enter their user name and password. Windows authentication (which authenticates DbNetTime users by their Widows login name) can be used by overwriting the existing authentication node in the web.config with the following;

<authentication mode="Windows">
</authentication>

Hide Answer


The XML page cannot be displayed
I'm getting the following error:

The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.


--------------------------------------------------------------------------------

A name was started with an invalid character. Error processing resource 'http://hp_laptop/dbnetsuite/menu.aspx'. Line 1, P...

<%@ Page language="C#" Inherits="DbNetLink.Web.SuiteMenu"%>
-^
Show Answer
This error indicates that ASP.NET is either not installed or has not been registered with IIS.



If you believe ASP.NET is installed then try running



"C:\WINDOWS\Microsoft.NET\Framework\{version}\aspnet_regiis.exe"

Hide Answer