22 May 2006
Commerce Starter Kit - SQL 2000
Spook from the Commerce Starter Kit just released a video to demostrate the process of migrating itself to SQL 2000 instead of the default SQLExpress.
In addition, it demoed in a real world scenario where you are working against a real third party hosting which really suits my stomach.
A few issues I encountered.
- ASP Membership SQL Script is corrupted. I'm not sure if it's a problem with my machine, but I couldn't get it. Solution? I used my aspnet_regsql tool that came with .NET 2.0 and successfully registered all the needed tables and store procedures.
- Upon the first time when I tried to executed the 2000 sql scripots, I got permission denied. The issue? It's because I didn't really understood how SQL Mangement Studio Express really worked. You need to display the "SQL Editor" Toolbar. Once it's dispalyed, you'll see a dropdown of the list of database. Choose the one that you have permission to, and you should be fine.
Another cool demostration is rather generic, but Spook demostrated really well in terms of how to make your .NET 2.0 application connect to SQL 2000.
The connection string should look something like this
<add name="CommerceTemplate"
connectionString="
Data Source=Your Database IP Address;
User ID=Your SQL Server User ID;
Password=Your sql Server Password;
database=Your sql Server database"
providerName="System.Data.SqlClient" />
DataSource: Point it to your database (IP Address will be a better idea)
UserID : Your SQL server username
Password : Your sql server password
database : The database you are going to work against
Interesting enough, I've been using another way, though somehwat similar connection
<add name="MyConnectionString"
connectionString="
Data Source=Your Database IP Address;
Initial Catalog=Your sql Server database;
Persist Security Info=True;
User ID=Your SQL Server User ID;
Password=Your sql Server Password;
"
providerName="System.Data.SqlClient" />
As you can see, instead of using database, I used Initial Catalog and I have one more attribute "Persist Security Info = true";
Now, I'm not sure what "Persist Secuirty Info" is, so I'll have to research a bit more it. Though I'm afraid I shouldn't have done that.
One Last piece that I want to bring up is the ASPNET Membership managment download. It's excellent and provides you with a ready to use user mangement interface. A few issues though
- Missing Create User capability
- Missing Change Password Capability
- Delete User should have confirmation before delete. (I know that because I accidently deleted one of mine)
- Edit User, the html is somewhat messed up. Need to re-organize a little bit.
I already have mine add-on implemented. I will release it in my "Files" section in a few days.
Hope it helps everyone who wish to get started with Commerce Starter Kits using SQL 2000.
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
Comment Policy: No HTML allowed. URIs and line breaks are converted automatically. Your e–mail address will not show up on any public page.