Page 1 of 1
MS SQL Server
Posted: Fri Jul 21, 2006 3:23 am
by 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.
Posted: Fri Jul 21, 2006 3:43 am
by 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.
Posted: Fri Jul 21, 2006 4:30 am
by 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!
Posted: Fri Jul 21, 2006 5:18 am
by 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$).