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   [ + ] Show 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.

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
Answer this question or Comment on this question for clarity