SQL Server support

I'm having the exact same issue here, on a LAMP system:
Error message is:

Debug:
'Exception: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for \'record2_vessels_authorizedfrom\''
in views_data_export_plugin_query_default_batched->execute() (line 841 of /var/www/vhosts/iotc.org/httpdocs/sites/all/modules/views_data_export/plugins/views_data_export_plugin_display_export.inc).

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'iotc.views_data_export_index_8' doesn't exist: SELECT COUNT(*) FROM {views_data_export_index_8}; Array ( ) in views_data_export_plugin_display_export->execute_initial() (line 264 of /var/www/vhosts/iotc.org/httpdocs/sites/all/modules/views_data_export/plugins/views_data_export_plugin_display_export.inc).

When batch export is activated... I'm running 7.x-3.0-beta6 but it fails also with 7.x-3.0-dev.

I'm running Drupal 7.12, Views 7.x-3.2 and ctools 7.x-1.2

Seems like the module can't create the required MySQL table view...
Any help would be appreciated.

This is not the same issue.

This is not fixed. I am guessing it has to do with the SQL driver module. I am going to move over there as I just ran into this. I believe that what is going on is views data export is creating a temp table that the sql driver is not playing nicely with? Maybe I am wrong.

I will try with the 2.x version to see if that resolves it.

This totally looks like temp table not created.

This was fixed in 7.x-2.x, temporary table support was completely broken in 7.x-1.x.

Support for temporary tables was added in this commit:

http://cgit.drupalcode.org/sqlsrv/commit/?id=8084e74

This is the issue about it

#1860152: Support for temporary tables is broken

Ok so I think I finally setup an environment that runs 2.x. I was having some issues with not having ODBC 11 installed.

So I have the latest 7.x-2.x version enabled.

PHP 5.6.9
MS SQL Server PDO extension 3.2.0.0

I am still getting the same error though.

PDOException: SQLSTATE[42S02]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid object name 'views_data_export_index_13'.: SELECT COUNT(*) FROM views_data_export_index_13; Array ( ) in views_data_export_plugin_display_export->execute_initial() (line 301 of C:\inetpub\wwwroot\drupal\sites\all\modules\contrib\views_data_export\plugins\views_data_export_plugin_display_export.inc).

and

User notice:
'Exception: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword \'SELECT\'.'
in views_data_export_plugin_query_default_batched->execute() (line 899 of C:\inetpub\wwwroot\drupal\sites\all\modules\contrib\views_data_export\plugins\views_data_export_plugin_display_export.inc).

Would need to take a closer look, but probably this is failing:

        $query->preExecute();
        $args = $query->getArguments();
        $insert_query = 'CREATE TABLE {' . $display_handler->index_tablename() . '} SELECT @row := @row + 1 AS ' . $display_handler->batched_execution_state->sandbox['weight_field_alias'] . ', ' . implode(', ', $select_aliases) . ' FROM (' . (string)$query . ') AS cl, (SELECT @row := 0) AS r';
        db_query($insert_query, $args);

Your prolly right, it is probably the SELECT implementation.

Yes it was, a long time ago indeed:

#2015361: SQL Server Compatibility

There's nothing that can be done for this at the database driver level. The module is manually issuing a very MySQL specific query.

If anything is to be done, it's in the contrib that builds this query.