WiseSqlError during unattended installation
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 ?
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
Answers (5)
Please log in to answer
Posted by:
anonymous_9363
13 years ago
WiseSqlAuth="NT"Only public properties are valid on the command line. All others are ignored.
Posted by:
shijith.anandan
13 years ago
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.
(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.
Posted by:
anonymous_9363
13 years ago
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.
Posted by:
shijith.anandan
13 years ago
Ya , it works fine now , changed the property type to public and went abt doing the packagin process!! thanks... :)
Posted by:
zzpack
13 years ago
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?
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?
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.