Hi everybody,
Background
I am a senior citizen (not that that makes any damned difference) who has taken on the daunting challenge of putting an end to freeway traffic congestion, hence, this also involves, a software challenge. My OS is Windows 2000 Professional. I purchased Microsoft FrontPage 2003, the
book FrontPage 2003 Inside Out, by Jim Buyens, and began building a Web site to engage commuters in the battle to put an end to being stuck in traffic. I put the Web site on a hosted Microsoft Windows 2003 server so that meant I could not use the self-registration system provided in FrontPage. I attempted to put the ASP.NET self-registration system that Buyens provided in Inside Extras but I ran into trouble hooking it up to Microsoft Access so I went to the Microsoft Help Web site.
Looking for VB code
I was looking for code when I discovered that I should have .NET Framework 1.1, so I downloaded it. Then I discovered a wonderful thing called ASP.NET Web Matrix, so I downloaded it. Then I discovered an answer to my dreams: the ASP.NET Commerce Starter Kit. Not only does it provide the e-commerce solution but it also has a self-registration system. Wow! Somewhere back there I discovered I needed Microsoft SQL MSDE and there it was?free. Wow, again. I downloaded it, that is, sql2ksp3, and now I thought I was ready to see what I have downloaded and put it all together.
I was amazed
The ASP.NET Web Matrix seems like an answer to prayer. Having fooled around quite a bit with VBA for Excel 5 several years ago, this tool looks marvelous to me. I know I am really going to enjoy working with it, but you guessed it, I have a problem.
The Problem
I have been unable to install ASP.NET Commerce Starter Kit because it will not connect to the SQL MSDE database. Every attempt to install ends up a failure because when I Click on Test Connection in the ASP.NET Commerce Database dialog box I get the Failed Connection textbox that reads, ?Unsuccessful Database Connection.? What I am seeing again, though, is localhost in the dropdown textbox on the ASP.NET Commerce Database dialog box. When I changed that to local in ASP.NET Web Matrix Connect to Database dialog box I was able to get a connection to the SQL MSDE Database. Do you suppose that is the problem in this case? Also, a couple of unknowns in my mind: I don?t have IIS on Windows 2000 Professional so I unchecked the checkbox that asks, Support IIS?, but I get the same result either way. In addition, I Clicked the local radio button when the screen asked the remote or local question. Well, I just now tried to install using the remote option, and I got an install. Am I expecting too much to install it locally and work with it on my computer until I get right before I publish it to the host server? I think I have Cassini because I have ASP.NET Web Matrix, and I also have the SQL MSDE Engine now so what am I missing?
I believe
I believe I will love everything I have gotten from the ASP.NET Team once I get it all working. Thanks for some great programming and tools.
Ken