Unable to run The sql script file

[wah...@arrowlabs.co]

Please find my sample project source code and sql script

I am trying to run your sample but still not able to execute the sql file script.

Please give response with some suggestion then may i will able to run my sql script file.

I have already checked your sample that you have provided in the repository but still no success.

During installation it does not give any error . it installed successfully but not able to find my script file to run and create the database table.
I am using the wixdatasourceextension.
Kind regards,
waiting for your response.

[Daniel Doubrovkine]

Please attach a log.

--
You received this message because you are subscribed to the Google Groups "msiext" group.
To unsubscribe from this group and stop receiving emails from it, send an email to msiext+un...@googlegroups.com.
To post to this group, send email to msi...@googlegroups.com.
Visit this group at https://groups.google.com/group/msiext.
For more options, visit https://groups.google.com/d/optout.

--

dB. | Moscow - Geneva - Seattle - New York
code.dblock.org - @dblockdotorg - artsy.net - github/dblock

[wah...@arrowlabs.co]

Please find the logs in the email attachment. 

Regards,

waqar

[Daniel Doubrovkine]

I don't see anything wrong here. Have you tried the demo project included, does that one work as is?

[Daniel Doubrovkine]

I bet the SQL is executing on a different database, run a SQL profiler, are you seeing those commands run on something else?

[wah...@arrowlabs.co]

I did not see that  my sql script file is executing in Sql Profiler. Only i checked that the installer only check that the database exist or not query that run through installer. 

Remaining i am unable to build the test sample because its giving the following error

1>------ Build started: Project: Version, Configuration: Debug Any CPU ------

1>  Version -> C:\Users\user\Downloads\msiext-master (1) - Copy\msiext-master\src\Version\bin\Debug\Version.dll

2>------ Build started: Project: DataSource, Configuration: Debug Win32 ------

2>  DataSource.vcxproj -> C:\Users\user\Downloads\msiext-master (1) - Copy\msiext-master\target\Debug\bin\DataSource.dll

3>------ Build started: Project: DataSourceExtension (Source\Wix Extensions\DataSourceExtension\DataSourceExtension), Configuration: Debug x86 ------

4>------ Build started: Project: WixDataSourceExtension, Configuration: Debug Any CPU ------

4>  WixDataSourceExtension -> C:\Users\user\Downloads\msiext-master (1) - Copy\msiext-master\target\Debug\bin\WixDataSourceExtension.dll

5>------ Build started: Project: MSSQLDatabaseMsi, Configuration: Debug x86 ------

5>C:\Users\user\Downloads\msiext-master (1) - Copy\msiext-master\externals\wix\wix2010.targets(2508,7): error MSB4064: The "SuppressBuildInfo" parameter is not supported by the "Light" task. Verify the parameter exists on the task, and it is a settable public instance property.

5>C:\Users\user\Downloads\msiext-master (1) - Copy\msiext-master\externals\wix\wix2010.targets(2472,5): error MSB4063: The "Light" task could not be initialized with its input parameters. 

5>Done building project "MSSQLDatabaseMsi.wixproj" -- FAILED.

Kindly your prompt response will be very helpful if you  guide me in right direction

[Daniel Doubrovkine]

Looks like this is caused by a different version of Wix - I've never seen these errors. It has been a while since I dealt with all of this, sorry I cannot be of much help.

[wah...@arrowlabs.co]

WiX.Toolset.3.9.1208.0 i am using this version. Kindly tell me which version have to install that is compatible to this. Waiting for the response.

[wah...@arrowlabs.co]

Any body help me on this issue to run the sql script in wix using datasource extension. Currently i am stuck on this point. 

I have placed ths sample script and code in the attachment. 

[Daniel Doubrovkine]

Check out https://github.com/dblock/msiext/blob/master/CONTRIBUTING.md.

[wah...@arrowlabs.co]

Dear Daniel,

The problem is still same. No Idea how to fix to execute the SQL Database script through wixdatasourceExtension. 

I did not find any thing on the following Link.

[Daniel Doubrovkine]

Sorry I cannot be more helpful.

[wah...@arrowlabs.co]

Dear Daniel,

Kindly just provide any working sample that have the wix code and run the scripts. Because the demos you have on repository  does not work also

Otherwise i already have the sample code and script in the attached post to just some modification and may be it will work.

Waiting for your kind response. 

Regards,

Waqar

[wah...@arrowlabs.co]

Thanks Daniel,

I am able to done.

Thanks for your  support.

[Daniel Doubrovkine]

What was the problem?