Navision and SQL Server

Dynamics 365 Business Central/NAV Technical Forum
#1

Hi, Could somebody tell me how Attain access’s SQL server ( Connectivity ) ? Thanks in advance garry

#2

Attain access Navision SQL server database using c/odbc.

#3

C/ODBC is a tool used to access the native Navision database from any external application that supports ODBC data sources. It has nothing to do with SQL Server and can’t even be used with the SQL Server Option for Navision. Garry, what do you mean with connectivity?

#4

quote:

It has nothing to do with SQL Server and can’t even be used with the SQL Server Option for Navision

I agree with you when talking about C/ODBC, but the “communication protocol” used by SQL Server is - as far as I know - ODBC, so it’s also used by the Attain-client.

#5

Yes, C/AL connects to SQL via ODBC. I remember, some years back, there was talk about changing this (using some other technology) and thus making the connection faster - don’t know if these plans have been abandoned, though.

#6

Yes Joerg, Navision uses SQL Server’s ODBC driver. But C/ODBC is the proprietary Navision database ODBC driver and thus will have no use on an SQL environment.

#7

Changing it (to oledb, being the only option) would not make the connection or anything else faster. There are no plans to do this.

#8

Thanks everybody, ODBC it is…

#9

Hi, Another question: any idea where is the source ie. DSN is thx in advance garry

#10

Navision does not use DSNs. It builds the connection string internally from the properties you give in the Database Open dialog. It therefore does not rely on the user’s computer being set up with appropriate DSNs.

#11

thx for your help