Hi everyone,

When deploying a small application in hostmysite I ran into a problem using the default ASPNETDB.MDF. Soon I found out that hostmysite won't work with this express file, so I found the way to create a .bak file from it.

Now my question is the following:
I need to send this so they create a complete new database, and therefore, it will cost me 15 bucks more a month? Isnt there another solution apart from using an access file?

Thanks in advance.

You do get a 150MB MySQL DB free with your account. I don't use .NET so I don't know if you can use MySQL with it.

SQL server is the best way to go though. Stay away from access.

Thanx Jason101,

I'll look into that.

Does anyone have any other solutions.

Cheers.

ASP.NET 2.0 membership can be maintained using XML files, as well as an Access or SQL database. It may even be possible on MySQL, but I've never had reason to investigate.

Try creating an ODBC connection to a MySQL database and use that rather then MS SQL. If you test locally and all is fine you can use the free version of EMS MyManager to build the database on HMS.

If you need to move data attach an Access front end to the HMS MySQL database using the IP addess in an ODBC connection. Use the Access system to move data between databases.

A better way, though it costs money, is to purchase the full version of EMS MyManager for interfaces to MySQL. The paid version has multiple interface/conversion tools.

HTH