data connector problem

[aminbaik88]

hello,
i tried to setup data connector to transfer the logs the connection test is working
but nothing transferred to database and i see that there is no tables has been created
the ever log error is:

Data Transferring to sql server failed due to the following reason: Failed to offload `public_recording_participant`: Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'IF'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData() at

any suggest ?
thanks.

 

[MichaelB_3CX]

Version of the SQL server?

 

[aminbaik88]

2024 | 12.0.6179.1

 

[KyriacosS_3CX]

Hi,
12.0.6179.1 is SQL Server 2014.

The Data connector is for the current SQL Server 2022, which you can get via: https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Best,
KS.

 

[aminbaik88]

then i have to use SQL 2022 only ? is there any other way ?
thanks

 

[KyriacosS_3CX]

For Microsoft SQL server, yes. If that is not easy, then one of the other supported targets can be considered.