Been trying for the last two weeks to get a .NET version of the scheduler to work in a shared hosting environment at Accuwebhosting. Their support people have been trying to help, but today they informed us that it is not possible to install the scheduler on their servers because they don’t support a local database in the App_Data folder.
Does anyone know of a hosting company that does?
Hello,
you don’t have to use the mdf database as an local file. You can either attach it to MSSQL server using MSSQL Management Studio screencast.com/t/IFOASXsAKulm
After that you’ll need to update the connection string in web.config to connect the appropriate server. This will work with any hosting where your mssql account has permissions to attach the databases.
Or you can manually create the required DB table in the database you have access to, and also update the connection string.
The table structure is pretty simple,
Not using the recurring events:CREATE TABLE [Events] (
[id] INT IDENTITY (1, 1) NOT NULL,
[text] TEXT NULL,
[start_date] DATETIME NOT NULL,
[end_date] DATETIME NOT NULL,
PRIMARY KEY (id)
);
Or, events with support of recurrings:CREATE TABLE [Recurring] (
[id] INT IDENTITY (1, 1) NOT NULL,
[text] TEXT NULL,
[start_date] DATETIME NOT NULL,
[end_date] DATETIME NOT NULL,
[event_length] BIGINT NULL,
[rec_type] NVARCHAR(50) NULL,
[event_pid] INT NULL,
PRIMARY KEY (id)
);