DNN problem while executing files
DNN has problems while executing SQL file
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 will truncates it to
set @var=@varSolution:
This problem is due to the format of the sqldataprovider you are trying to upload.
Check the format of sql script files.
DNN requires its sql script files to be in a unicode format.
1. Open sql script in Notepad;
2. Goto File > Save As
3. Save the file file over the existing sql script however specify the file type as Unicode.
DNN should now execute the script correctly.
Do not forget to replace the dbo. with {databaseOwner} and prefix table name with the {objectQualifier} tag