SQL Server 2005 troubles.

Jun 5, 2009 at 7:33 PM

I was using xml to previously store the blog data.  I have recently configured a SQL Server database to store the blog data.  With the xml data, the blog seems to show up fine.  I have been able to connect to my database and now the blog doesnt show up at all, rather it shows some weird characters.  Here is a short snippet of what it has been returning:

�`I�%&/m�{J�J��t��`$ؐ@�����iG#)�*��eVe]f@�흼��{���{��;�N'���

I don't know if this is an encoding issue or what but I would really like someone to help me in figureing out what the problem could be.  Thank you in advance!


Larry Luangrath

Jun 5, 2009 at 8:51 PM

I was able to fix the problem by just completly wiping out the site and setting up a fresh one with the SQL server db.  That seemed to do the trick.