MS SQL Server

[mikesm]

Hi.
I have a problem with MS SQL Server plug-in. Installed instance of MS SQL Server Express SP1 isn't able make bulk insert commands! There's no posibility to read files from SUPPORTDIR by MS SQL Server Express SP1 on WXP.

[Gizm0]

There is was a bug on plugin which is fixed on InstallAware 6.0 SP1.
As a workaround use the #FILESCRIPT#$SUPPORTDIR$\\myscript.sql command on the script window , and insert the myscript.sql file as a support file on your project.It should work fine.

[mikesm]

It isn't right, it doesn't work correct!
Yes, I can create table, alter table, and so on..., but i can't use "BULK INSERT" command, because the $SUPPORTDIR$ isn't accesible to MS SQL Server Express SP1. For example command "BULK INSERT tableName FROM '$SUPPORTDIR$tableDataFile.tbl' WITH (CODEPAGE='1250')" ends with error access denied to file "C:\\Dokuments and settings\\Username\\Local settings\\Temp\\mia\\tableDataFile.tbl".

Files in $SUPPORTDIR$ aren't accesible to MS SQL Server Express SP1!

[MichaelNesmith]

I think Gizmo was suggesting something else, and you misunderstood.

Simply install the latest version of InstallAware from the public website - that version has no issues with the SQL Server plug-in, and you may use it to connect to your database, no need to worry about $SUPPORTDIR$.

Gizmo's post was referring to the #FILESCRIPT# option - please read the help file entry on the MS SQL Server plug-in for more information on this option (and what he really meant by $SUPPORTDIR$).