November 2005 - Posts
I was looking for something like that to understand and use the provider model. Great job!
This is another great evening tomorrow in Dublin, the chance to meet the Channel 9 guy himself, Robert Scoble.Register here
We will also have an Expert Panel session, where any one in the room can challenge the experts (an MVP, a Microsoft Regional Director, the head of INETA Ireland and of course a Microsoft evangelist, not bad not bad), asking tough questions on .Net technologies, databases, web services, etc…
The experts will judge the most intriguing question and the winner will be rewarded with some nice books!
John Rivard explain in this post in deep details why VS 2005 target only .Net 2.0. Apparently they are working on supporting also other versions. Cool!
I really enjoy the new SQL 2005 management studio, everything I need in one location. However I have issues when I try to connect to any production databases (SQL 2000 or 2005).
In the Connect To Server windows, if I browse for any remote services, I can see my databases, but I have all the time the same message if I try to connect to one of them ‘under the default settings SQL Server does not allow remote connections (provider, etc…)
I double checked SQL Surface tool and Named Pipes and TCP/IP protocols are enabled, I read already few blogs and forums on the subject, but still don’t know what to do.
This is what it takes when you are unlucky (or lucky depends on the day) when you are the lonely developer in your company and you have two weeks to maintain and migrate 25 websites (note: on the left, yes an Apple G5 for the creative side of my brain, and not in the picture three more PCs!)
Click on the picture to enlarge
Two days on this issue, probably easy one but hard stuff for an average developer like me!
Sadly a proof that you can’t really depend on .Net 2.0 books yet. I believe the lack of experience from many means we have to survive only with Scott Guthrie and his team.
Anyway what happens here make sense when you finally see the light but at the start it baffled me for too much precious little hours.
First I installed SQL 2005, then VS 2005 without SQL Express 2005. Then I run in a lot of problems trying to setup the Membership provider correctly and make it working with SQL 2005. I am lucky enough to have on my bookshelf 99% of the ASP.Net 2.0 litterature but found nothing on the subject.
All the time when I was trying to setup some users with the Web admin Tool, always the same message ‘Unable to access the datastore’.
The solution is not that easy. I try to create a datasource and bind it to a web control, everything is OK. So it’s not a bad connection string.
Finally I decided to go through all the recent Scott’s posts and I discover this gem ! The trick is that ASP.Net 2.0 is setup by default to talk to SQL Express (why oh why the setup can’t modify automatically this behavior I don’t know??). So Scott give the easy solution which is to create a connection string in your config file using LocalSqlServer as the name and then to link the data source to your local SQL 2005 Db.
I wish to have this fix in a service pack. One thing I don’t understand. To use the ASP.Net configuration MMC snap in you need to have IIS installed. I know you can use VS 2005 without IIS, so how in this case do you reach the snap in?
OK I know some people can say I have a constant bad attitude regarding Microsoft products, but hey I like their products and I like also to say when something goes right or wrong.
Here I want to say bravo for the HTML editor in VS 2005. It's really a great job, no more mess with my code reformatted.
One thing I really enjoy is the fact I can collapse any nested div or table element when I am writing my code. It's make the code much more readable and because I am now moving away more and more from the table and use more CSS and div tags. I finally disabled the HTML intellisense validation because I disagree with some of the rules, it could be nice to have some granularity on the level of error the tool report or not. Actually it's just on or off.
After one year of tests on the different betas, I finally start to write some real code. As I say before, I don't use really the migration tool, I prefer to start from a clean project and copy and paste what I need. I know it's a slow process, but I am quite sure its a winning situation in the long term. I hope also very soon to implement the new stuff like master pages, or web parts.
Ireland .Net Developers Alliance has been scobleized!
Robert will be in Dublin on the 1st of December.
More Posts Next page »