Code: Select all
~InstallAware Clipboard Data~
~MS SQL Server~
~{93862E2E-767F-40B6-ADDA-57E51F15BA71}~
~$SERVERNAME$,$INSTANCENAME$,$SQLDATABASE$,$SQLUSER$,$SQLPASSWORD$,SQLRESULT,#FILESCRIPT#$SUPPORTDIR$\pasdb.sql,FALSE,TRUE~
~mMSSQLIDE.dll\mMSSQLExec.dll~
Nothing happens when I run it. The result variable SQLRESULT returns SUCCESS but not a single line of code in pasdb.sql has been executed on the SQL Server database. If I run the contents of the file directly in SQL Server Management Studio it works.
If I try to use the exact same parameters (server, database, user etc) and create a simple table as the content of the sql script textbox it also works, like this for example:
Code: Select all
~InstallAware Clipboard Data~
~MS SQL Server~
~{93862E2E-767F-40B6-ADDA-57E51F15BA71}~
~$SERVERNAME$,$INSTANCENAME$,$SQLDATABASE$,$SQLUSER$,$SQLPASSWORD$,SQLRESULT,"CREATE TABLE Test (ID int)",FALSE,TRUE~
~mMSSQLIDE.dll\mMSSQLExec.dll~
I have included pasdb.sql in the Support Files (creatives) in the Project manager and also checked during debug that the file exists in the support directory.
Seems like the #FILESCRIPT# thingy doesn't work properly. Any ideas of what could be wrong?