Hello,

I'd noticed when looking at the prices of hosting ASP websites that it was much cheaper if you used

a mysql database instead of mssql so this is the way that I coded everything.  I've been using the login

control too though so does this mean...

1) that I *need* a mssql database?

2) that this database will take up my 1 allocated mssql database with the webhost?

3) can I use mysql in the same website; it seems to be working ok with the developer server...

 
Many thanks folks,

Adam
 

Hi,

thank to the provider model in ASP.NET Z.0 it's easy to change the database you need for the LocalSqlServer connectionstring, which is used by membership features. You can write your own implementation to use MySQL but you could also give some of these a try: http://www.google.be/search?hl=en&q=asp.net+membership+provider+mysql&meta=.

Grz, Kris.

Just to expand what XIII said,

1) No you don't NEED a mssql database.

2) If you decided to use mssql for membership, roles, and profiles, then yes that would take up an allocated mssql database, but you can put other tables into it as well if you wanted.

3) Yes, you can use mysql, mssql, db2, oracle, and progress all within the same website (doing different things).

What you want to do as XIII said is to replace the MS SQL membership (and role/profile too if you are using them) provider with a MySQL membership provider.  Then you can use the Login control, Create User Wizard, LoginView contol, etc.  If you change to a MySQL Role provider, then you can do role based security in your web.config, or in your code.  If you change to a MySQL Profile provider, then you can do profiles as well.

Thanks very much for the responses chaps.  I'm going to give this a go; can't say I'm particularly

optimistic as I don't really know what I'm doing or what most of the instructions mean :-) but would

be lovely if I could get it working so worth spending a few hours bashing away at it!

Cheers,

 Adam

 

I just thought... I'm using the MySql Connector/Net 1.0... is this something which will runnable on your

average webserver providers system... i.e. will this library be somehow embedded in the stuff I upload to

the web hosting company or will it have to be something they have installed on their own server?

Sorry for my ignorance... that's the problem with ASP.NET etc, you get all this power then suddenly

realise you don't know what the hell you're doing!

A
 

Hi,

normally you'll upload the .dll (assembly) to the /bin subfolder. Make sure that this assembly runs on the same .NET framework that you need, which is 2.0. If it's a mysql provider that I pointed out to in my former reply you should be good to go since providers were something introduced in ASP.NET 2.0.

Grz, Kris.