Hi,

I mentioned several times but I couldn't find a solution.

I still can't understand that some people can install and some people gtet errors.

Because there are important errors in installation script files or I think so.

After I tried many times to install 4.3.1 on SQL Server 2000 and 2005, everytime I tried to new install I checked the "Providers\DataProviders\SqlDataProvider" folder for error logs and I saw many errors in log files. I fixed the sql statements in script files and  tried to install again. Finally I could finish to fix most of the errors and succeed to install 4.3.1

The errors in script files are related with small case upper case problem.

For example I got this error.Please check it , it is easy to understand:

System.Data.SqlClient.SqlException: Must declare the variable '@moduleid'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 148
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 282

CREATE procedure dbo.dnn_GetModuleSetting

@ModuleId      int,
@SettingName   nvarchar(50)

as

select
'SettingValue' = case when dnn_Files.FileName is null then dnn_ModuleSettings.SettingValue else dnn_Files.Folder + dnn_Files.FileName end

from dnn_ModuleSettings
left outer join dnn_Files on dnn_ModuleSettings.SettingValue = 'fileid=' +
convert(varchar,dnn_Files.FileID)
where SettingName = @SettingName and moduleid=@moduleid

What I have done is just changing @moduleid to @ModuleId and after another installation I didn't get this error.

I still can't understand why some people didn't get any error while installing, we all use same install files.

Or SQL Server doesn't check smallcase uppercase.

I found many smallcase uppercase problem in sql provider scripts maybe 100 not 1 or 2.

So if some guys can install without any error with using this script files then this means there is another problem.

Thanks in advance