/bundles/itninjaweb/img/Breadcrumb_cap_w.png
Hi,
I m trying to deploy an "msi" file which was created using command line options as follows:

"path of WfWI.exe" "path of wsi file" /c /o "output folder" /s

There werent any problems in automating the "msi" creation but when i try to deploy it using the commmand line option as follows:

msiexec.exe /i "path of .msi" /qb /l* "C:\package.log" INSTALLDIR="installation path" ACCEPT="Yes" INSTALLMODE="Typical" WiseSqlAuth="NT"

I get the error " WiseSqlError :[Microsoft][ODBC Driver Manager] Data Source Name not found and no default driver specified

Can any help me out in solving this problem ?
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity

Answers

0
WiseSqlAuth="NT" Only public properties are valid on the command line. All others are ignored.
Answered 04/05/2011 by: VBScab
Red Belt

Please log in to comment
0
Hi thanks for ur reply!! but how to go about setting other properties which wud be prompted in dialog boxes during the installation process if it was done manually!
(for eg): In the installation of my application there is a prompt box for specifyin whether we have to go for "windows" or "sql" authentication.
Answered 04/05/2011 by: shijith.anandan
Senior Yellow Belt

Please log in to comment
0
The fact that you have a WSI implies that you have captured a legacy set-up, in which case you can either include the property and its value in your WSI, ready for compilation into the MSI or, if you need to give installers a choice, then change the property type to public.
Answered 04/05/2011 by: VBScab
Red Belt

Please log in to comment
0
Ya , it works fine now , changed the property type to public and went abt doing the packagin process!! thanks... :)
Answered 04/05/2011 by: shijith.anandan
Senior Yellow Belt

Please log in to comment
0
I too have a problem with this, WiseSqlError :[Microsoft][ODBC Driver Manager] Data Source Name not found and no default driver specified.

I have an application that works well to install using the source media. It is a .msi file and it installs a database. Sql server express 2005 is already installed on the client,
in order for the application to run.

Since it´s a .msi file I have created a .mst and added the following to the Property table: (I got the property names and values from the Dialogs table)
WISESQLAUTH NT
WISESQLSERVERNAME .
123_SQL_SERVER_PATH .

If I use the above values, during normal setup, it works well and the database 123 is visible if I go to Management Studio Express.

Now, when I run the command, msiexec /i appname.msi Transforms=appname.mst /qb,
after a while I get the above error, Data Source Name not found and no default driver specified.

Can you give me some tips how to proceed with this package?
Answered 08/18/2011 by: zzpack
Orange Senior Belt

Please log in to comment