{"id":55,"date":"2008-11-24T08:48:00","date_gmt":"2008-11-24T12:48:00","guid":{"rendered":"http:\/\/www.searchenginegenie.com\/programming-blog\/dnn-has-problems-while-executing-sql-file\/"},"modified":"2012-09-21T06:42:49","modified_gmt":"2012-09-21T10:42:49","slug":"dnn-has-problems-while-executing-sql-file","status":"publish","type":"post","link":"https:\/\/www.searchenginegenie.com\/programming-blog\/dnn-has-problems-while-executing-sql-file\/","title":{"rendered":"DNN has problems while executing SQL file"},"content":{"rendered":"<p><span id=\"ctl00_CPH_centerFront_ctl27_PageList1\"><span>Are You facing a problem with DNN while you try to install a module?<\/p>\n<p>Is DNN having problems in executing your file even it runs perfectly in Query Analyzer?<\/p>\n<p>For example<\/p>\n<p>If you have this line<\/p>\n<p>set @var = @var+ 1.<\/p>\n<p>DNN fails to execute it.<\/p>\n<p>If you remove the blanks like<\/p>\n<p>set @var=@var+1<\/p>\n<p>DNN will truncates it to<\/p>\n<p>set @var=@var<span id=\"ctl00_CPH_centerFront_ctl27_PageList1\"><span>Solution:<\/p>\n<p><span id=\"ctl00_CPH_centerFront_ctl27_PageList1\"><span><span id=\"ctl00_CPH_centerFront_ctl27_PageList1\"><span>This  problem is due to the format of the sqldataprovider you are trying to upload.<\/p>\n<p>Check the format of <span id=\"ctl00_CPH_centerFront_ctl27_PageList1\"><span><span id=\"ctl00_CPH_centerFront_ctl27_PageList1\"><span><span id=\"ctl00_CPH_centerFront_ctl27_PageList1\"><span><span id=\"ctl00_CPH_centerFront_ctl27_PageList1\"><span>sql script files.<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n<p>DNN requires its sql script files to be in a unicode format.<\/p>\n<p><\/span><\/span><\/span><\/span><\/p>\n<p>1. Open sql script in Notepad;<\/p>\n<p>2. Goto File &gt; Save As<\/p>\n<p>3. Save the file file over the existing sql script however specify the file type as Unicode.<\/p>\n<p>DNN should now execute the script correctly.<\/p>\n<p>Do not forget to replace the dbo. with {databaseOwner} and prefix table name with the {objectQualifier} tag<\/p>\n<p><\/span><\/span><\/p>\n<p><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Are You facing a problem with DNN while you try to install a module? Is DNN having problems in executing your file even it runs perfectly in Query Analyzer? For example If you have this line set @var = @var+ 1. DNN fails to execute it. If you remove the blanks like set @var=@var+1 DNN [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[60],"class_list":["post-55","post","type-post","status-publish","format-standard","hentry","category-troubleshoot","tag-dnn-problem-while-executing-files"],"_links":{"self":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts\/55","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/comments?post=55"}],"version-history":[{"count":4,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts\/55\/revisions"}],"predecessor-version":[{"id":422,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts\/55\/revisions\/422"}],"wp:attachment":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/media?parent=55"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/categories?post=55"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/tags?post=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}