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=@var

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

Most of the programmers were having confusion with .cgi and .pl.
Since the file with .cgi extension is using the perl code and it is running fine.
But the file with .pl extension which contains the perl code does not run.

Here is the answer for you

File extensions are generally meaningless. Windows preserves a map between programs and the file extensions which should be accustomed to open them. Apache, a web server which performs something similar like windows. CGI is an interface approved upon by rfc 3875 which is mainly used for passing information from web requests to executables. CGI has capable of bypassing data to several types of executable which can recognize it. Your .cgi files are possibly parsed for #! line which is responsible for mapping your exact .cgi file to be executed by Perl. Briefly, file extensions are virtually meaningless.

The extension simply notifies the server about how to handle it. cgi extensions tell it to run the script with whatsoever program is programmed at the top #! line. If the server is not notified to do the same with .pl files in that case it will not know what to do with it.

If you are lying on an apache server, adding up this line to the .htaccess file will make it parse .pl files through CGI
AddHandler cgi-script .pl