My digital scrapbook

SQL Server Connection in ASP.NET

on under Software and Web DevelopmentBe the first to comment

I choose to write in English because seems many people held problem like I do. I had problem with SQL Server 2000, SQL Server 2005 (Express) in regular basis. I had some thought that the problem related to :

  1. Permission
    Please check your APP_DATA and APP_CODE folder permission, make sure it contains ASPNET and NETWORK SERVICE. Don't add all just try one by one, if you failed on ASPNET user then you could check NETWORK SERVICE also.
  2. Web.Config Setting
    If you want your DATA stored on APP_DATA make sure had correct connectionString (this just example), change the necessary configuration according to your machine and SQL Instance

    <add name="DintCoreDB" connectionString="Data Source=DINT\SQLEXPRESS; AttachDBFilename=|DataDirectory|DintCoreDB.mdf; Integrated Security=true; User Instance=true"/>

  3. SQL Server it self
    SQL Server 2005 with Advanced Service had tricky configuration and it will make a headache, make sure you install this first before all things like Visual Studio. Replacing old instance could direct you into big mess which APP_DATA can't work properly. I don't know why this happen. I keep safe for this one as I don't have much time to experiment.

Hope this works. Laughing

Update to BlogEngine.NET 1.3

on under Uncategorized • One Comment

I am succesfully update my BlogEngine into version 1.3. It's not preety easy because we need to adjust the settings.xml to be compatible with BlogEngine.NET 1.3 and some theme function is deprecated which should required some modification in my own theme.

Maybe if you send me email, I would applogoize that I would be late to reply since my Portable Mozilla Thunderbird getting stupid Yell and need to backup all my stuff over there. I hope I could fix this soon and trying to fetch my hundreds megabyte email from Gmail. Wacky.

Special Award from Shane and Peter

on under Uncategorized • Be the first to comment

My Windows XP give me sluggish perfomance and ASIO not work well. This condition force me to reinstall my Windows to clean state and installing all applications from beginning. I open my Thunderbird (email client) to check my recent email after installation process is done.

One of email is come from Shane, an entreprenerd man from outside of Indonesia, it's bit suprise when he wrote me a great news. I'm one of Shane & Peter Interview winner. I was posted a journal according to their questions. Thank you for Shane & Peter.

It's fun to be part of this event and many posted great answer. We're live to help people and knowledge should be shared.