I've had a go connecting to SQL server remotely and creating the tables I need (with scripts). This worked for the MS Personal Website Starter Kit.
However, I'm now using an extended version of this starter website, and I'm getting errors that it is using incompatible types - i.e. it must be using SQL Server 2005 types which, of course, your SQL Server 2000 doesn't recognise.
Is there any chance my website could be transferred to a server running SQL Server 2005? If so, is there a charge? Nothing would actually have to be moved (I'm still setting it up) so the current stuff could be deleted and I'd just set up on the new server.
|