Hello,
I have an WiX installer that is creating a database and I have that part of the installer working. I also run a SQL script. I followed the tutorial at http://wix.tramontana.co.hu/tutorial/sql/creating-a-database and generally have things running. The SQL script file itself references other files that are co-located with the SQL script file on disk. The problem is the SQL script can't find the those co-located files when it is run by the installer. The SQL script file and the needed support files are installed with my other files. It looks like it is looking for the support files in a windows installer temp directory (see below - C:\Windows\Installer\MSIAFFC.tmp). How do I resolve this. I think I need to copy the support files to the temp directory but I don't know the name of that ahead of time. Thanks, Here is a portion of my output log file: MSI (s) (04:CC) [12:28:57:807]: Executing op: ActionStart(Name=ExecuteSqlStrings,Description=Executing SQL Strings,) Action 12:28:57: ExecuteSqlStrings. Executing SQL Strings MSI (s) (04:CC) [12:28:57:809]: Executing op: CustomActionSchedule(Action=ExecuteSqlStrings,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********) MSI (s) (04:28) [12:28:57:813]: Invoking remote custom action. DLL: C:\Windows\Installer\MSIAFFC.tmp, Entrypoint: ExecuteSqlStrings ExecuteSqlStrings: Error 0x80040e14: failed to execute SQL string, error: CREATE ASSEMBLY failed because it could not read from the physical file 'ABC.dll': 50(The request is not supported.)., SQL key: MonitorSql SQL string: CREATE ASSEMBLY ABC FROM 'ABC.dll' WITH PERMISSION_SET = SAFE; Error 26204. Error -2147217900: failed to execute SQL string, error detail: CREATE ASSEMBLY failed because it could not read from the physical file 'ABC.dll': 50(The request is not supported.)., SQL key: MonitorSql SQL string: CREATE ASSEMBLY ABC FROM 'ABC.dll' WITH PERMISSION_SET = SAFE; MSI (s) (04!28) [12:29:07:501]: Product: ABC Processing (DP) Web Application -- Error 26204. Error -2147217900: failed to execute SQL string, error detail: CREATE ASSEMBLY failed because it could not read from the physical file 'ABC.dll': 50(The request is not supported.)., SQL key: MonitorSql SQL string: CREATE ASSEMBLY ABC FROM 'ABC.dll' WITH PERMISSION_SET = SAFE; ------------------------------------------------------------------------------ Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
