SQL ODBC driver for NAV2015

Roelof

I'm currently working on a ODBC driver connection for SQL to connect between NAV2015 and a 3rd party solution.
I created a new Data Source in the ODBC Data Source Administrator->System DSN->Add, and choose: SQL Server Native Client 11.0.
I tested the DataSource connection in Excel and it recognizes the NAV2015 database on the SQL server (SQL2012) but I can only do a read but not a write. The driver setup is defined as read/write.
Any ideas?

vremeni4

I think it might be easier if you connect the third party solution database to SQL server. You can use Linked Server in SQL.
I did this for mySQl database and it worked very well. (check properties for permissions to set read and write)
If the third party solution does not have a database then I would suggest you use WEb services (oData) as it will be more efficient.

I hope this helps.

Roelof

I'm trying to use the CDATA ODBC Driver, which is based on Web Services, but I'm having a hard time to connect to the 3rd party. That is the reason why I was looking into the SQL Driver.