problems with asp database and web host
I have a webspace with pipex web hosting on a shared server.
I have access to 3 sql server databases, but can only generate the tables by using sql statements.
I spent ages recreating the tables and stored procedures generated by aspnet_regsql.exe.
Now when I try and create a user I get the error:
The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version
I'm told that the database is SQL server 2000.
Unfortunately Pipex support is awful. They say that I can't run aspnet_regsql due to security (fair enough) but also that they can't run it either (because they are too lazy?).
So now i'm a bit stuck. Do i have to write my own login control to avoid me having to have a database generated by aspnet_regsql?
If anyone can offer me any help I would be grateful. I thought the login control was great when I first saw it, but if web hosts can't be bothered to set the tables up, it seems a bit wasted.
Any help would be very much appreciated at this point.