I guess it must be silly in my environment (I'm not a "heavy" developper) but I get the following error message when doing a MSI install of the server or the source environment...

must declare the variable '@hotsname' 

I tried command line MSI install but without much success

msiexec /i taskvisionsource_1.1.0.0.msi hostname="CBEZENCO01"


Any idea where shall I look ?

(PS I have VS.Net and VS.Net 2003 Beta installed on my XP machine. MSDE is running).

This is a bug in the .sql script within the MSI that is executed against the database. The variable is case sensitive and I found it declared as @hostName (or something like that). To see what I'm talking about, go to the subfolders where it was installed (Program Files\TaskVision) and look for .sql files. 

I have the same problem. But the after the error message box apears with this message the instaler cleans the directory where were it was installing.

What can I do?

The real simple solution formust declare the variable '@hostname'

this error comes about because your sql server is set to be case sensetive. in the script the variable declared is @hostName not @hostname note the difference in capital N and n. the solution is to reinstall your sql with default settings or change the colletion to SQL_Latin1_General_CP1_CI_AI. you can do this by running

start /wait <dvd path>\setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=password SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI

make sure you run tis command from 'setup bootstrap' folder. you do this by typing cdm at command prompt then using cd command to navigate to 'setup bootstrap' folder. If you have sql2000 you need to reinstall.

It might be an open door but: The errormessage indicates that you declare the variable as hotsname not hostname