Skip to main content

Posts

Showing posts from April, 2009

How to add a MS SQL server 2005 database connection in Netbeans

In Netbeans IDE, I was trying to add a Database connection to a MS SQL server 2005 database. After entering the correct parameters and locating the right jdbc driver (sqljdbc.jar), I was able to connect; however none of the tables showed up. After reading this , I decided to set the value of the schema property to dbo and it worked! To change the value of the schema property in your Netbeans's database connection, do the following: Right click on the connection Click on Disconnect Right click again on the connection Click properties Change the value of the Schema property

How to fix "incompatible schema version" error when deploying ASP.net application into a shared webhost

I was having the following error in my MS MVC application hosted in Mocha webhost : 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. My Problem was that even tho I already had created the database that contains the schema generated by aspnet_regsql.exe and I already edited my web.config to point the provider string to that database, the data was not there in the new database. To fix the problem I copied and pasted (using Management Studio) the data from the following tables from my working SQL Express 2008 development database to my production database at Mocha: SchemaVersions (the most important one to fix the "wrong schema" version) Applications Us