must declare the variable '@hostname'

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).

[486 byte] By [codefund.com] at [2008-2-17]

«« custom code serializer
»» MissingMethodException at Login

# 1

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.

codefund.com at 2007-9-8 >

top of Msdn Tech,Windows Forms,Windows Forms Sample Applications...

# 2

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?

codefund.com at 2007-9-8 >

# 3

The real simple solution for must 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.

vatozanab at 2007-9-8 >

# 4

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

RogiervandeRoer at 2007-9-8 >

Windows Forms Hot Topic

Windows Forms New Topic

Windows Forms

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'must declare the variable '@hostname'...'

must declare the variable '@hostname'

Windows Forms Hot Topic

Windows Forms New Topic

Windows Forms

Site Classified