Dear all,
I always get an error while uploading a SSI Web V8 Study to our MSSQL server.
On the webserver I can see the following errors in the log files:
SIWebVersion= 8_3_10 | ErrorNum= 217 | msg= Database error. Cannot drop tables. | Server Error: DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server]Incorrect syntax near 'ciw_map'. (SQL-42000) at /var/www/html/MyStudy/cgi-bin/admin.pl line 17.
The database user is dbowner so it should not be an error of the SQL access rights. Also an ODBC connection test with the used credentials was succesfull.
The upload is perfectly working for a MySQL databse but never worked for our MSSQL database.
DBD::ODBC and DBI::ODBC are both installed.
Any idea?
Many THX
Daniel