I moved it to another system running:
-Windows 2000 Server
-IIS 5.0
-BlueDragon Server
-MSDE
I applied all of the latest service packs, security updates, etc...
Intalled SQL Server Web Data Administrator and .NET framework.
I attached the database using sp_attach_db:
osql –U sa
password
Sp_attach_db ‘whatever',
@filename1 = ‘C:\Program Files\Microsoft SQL Server\MSSQL\Data\CollaborationTools.mdf',@filename2 = ‘C:\Program Files\Microsoft SQL Server\MSSQL\Data\CollaborationTools.ldf'go
I added my datasource using the ODBC Admin Tool...
Verified it using the BlueDragon Admin Datasources page....
But now I'm getting the error message:
'Could not run BEGIN TRANSACTION in database 'whatever' because the
database is read-only.'
Any help/guidance would be appreciated.
Thanks very much.
Shaun