# Navision and SQL Server **URL:** \ **Category:** Technical Forum\ **Created:** [August 12, 2004, 5:46pm UTC](https://www.dynamicsuser.net/t/navision-and-sql-server/12435 "2004-08-12T17:46:08Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![FormerMember](https://avatars.discourse-cdn.com/v4/letter/f/74df32/32.png) [@FormerMember](https://www.dynamicsuser.net/u/FormerMember)\ **Post date:** [August 12, 2004, 5:46pm UTC](https://www.dynamicsuser.net/t/navision-and-sql-server/12435/1 "2004-08-12T17:46:08Z")
Hi, Could somebody tell me how Attain access’s SQL server ( Connectivity ) ? Thanks in advance garry ---
**Author:** ![FormerMember](https://avatars.discourse-cdn.com/v4/letter/f/74df32/32.png) [@FormerMember](https://www.dynamicsuser.net/u/FormerMember)\ **Post date:** [August 17, 2004, 9:58am UTC](https://www.dynamicsuser.net/t/navision-and-sql-server/12435/2 "2004-08-17T09:58:34Z")
Attain access Navision SQL server database using c/odbc. ---
**Author:** ![Nelson](https://avatars.discourse-cdn.com/v4/letter/n/dec6dc/32.png) [@Nelson](https://www.dynamicsuser.net/u/Nelson)\ **Post date:** [August 17, 2004, 12:29pm UTC](https://www.dynamicsuser.net/t/navision-and-sql-server/12435/3 "2004-08-17T12:29:24Z")
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? ---
**Author:** ![stryk](https://avatars.discourse-cdn.com/v4/letter/s/ee59a6/32.png) [@stryk](https://www.dynamicsuser.net/u/stryk)\ **Post date:** [August 17, 2004, 1:53pm UTC](https://www.dynamicsuser.net/t/navision-and-sql-server/12435/4 "2004-08-17T13:53:43Z")
> 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. ---
**Author:** ![Steffen\_Voel](https://avatars.discourse-cdn.com/v4/letter/s/0ea827/32.png) [@Steffen\_Voel](https://www.dynamicsuser.net/u/Steffen_Voel)\ **Post date:** [August 17, 2004, 2:06pm UTC](https://www.dynamicsuser.net/t/navision-and-sql-server/12435/5 "2004-08-17T14:06:49Z")
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. ---
**Author:** ![Nelson](https://avatars.discourse-cdn.com/v4/letter/n/dec6dc/32.png) [@Nelson](https://www.dynamicsuser.net/u/Nelson)\ **Post date:** [August 17, 2004, 2:21pm UTC](https://www.dynamicsuser.net/t/navision-and-sql-server/12435/6 "2004-08-17T14:21:15Z")
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. ---
**Author:** ![robertc](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@robertc](https://www.dynamicsuser.net/u/robertc)\ **Post date:** [August 17, 2004, 4:13pm UTC](https://www.dynamicsuser.net/t/navision-and-sql-server/12435/7 "2004-08-17T16:13:23Z")
Changing it (to oledb, being the only option) would not make the connection or anything else faster. There are no plans to do this. ---
**Author:** ![FormerMember](https://avatars.discourse-cdn.com/v4/letter/f/74df32/32.png) [@FormerMember](https://www.dynamicsuser.net/u/FormerMember)\ **Post date:** [August 19, 2004, 12:24pm UTC](https://www.dynamicsuser.net/t/navision-and-sql-server/12435/8 "2004-08-19T12:24:15Z")
Thanks everybody, ODBC it is… ---
**Author:** ![FormerMember](https://avatars.discourse-cdn.com/v4/letter/f/74df32/32.png) [@FormerMember](https://www.dynamicsuser.net/u/FormerMember)\ **Post date:** [August 19, 2004, 12:27pm UTC](https://www.dynamicsuser.net/t/navision-and-sql-server/12435/9 "2004-08-19T12:27:36Z")
Hi, Another question: any idea where is the source ie. DSN is thx in advance garry ---
**Author:** ![robertc](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@robertc](https://www.dynamicsuser.net/u/robertc)\ **Post date:** [August 19, 2004, 1:52pm UTC](https://www.dynamicsuser.net/t/navision-and-sql-server/12435/10 "2004-08-19T13:52:59Z")
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. ---
**Author:** ![FormerMember](https://avatars.discourse-cdn.com/v4/letter/f/74df32/32.png) [@FormerMember](https://www.dynamicsuser.net/u/FormerMember)\ **Post date:** [August 19, 2004, 3:04pm UTC](https://www.dynamicsuser.net/t/navision-and-sql-server/12435/11 "2004-08-19T15:04:12Z")
thx for your help