Solution:
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
Post a Comment