# Problem connecting Navison as a Linked Server

**URL:** <https://www.dynamicsuser.net/t/problem-connecting-navison-as-a-linked-server/13331>\
**Category:** Developers Forum\
**Created:** [November 30, 2004, 7:57pm UTC](https://www.dynamicsuser.net/t/problem-connecting-navison-as-a-linked-server/13331 "2004-11-30T19:57:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![kbirecki](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@kbirecki](https://www.dynamicsuser.net/u/kbirecki)\
**Post date:** [November 30, 2004, 7:57pm UTC](https://www.dynamicsuser.net/t/problem-connecting-navison-as-a-linked-server/13331/1 "2004-11-30T19:57:21Z")

</div>

Greetings! I am trying to setup Navision as a Linked Server from within SQL Server 2000. SQL 2K has the ability to connect to external data sources via ODBC. I’m wondering if anyone has done this or knows anything about this. I’ve configured a Linked Server using a Provider Name of “Microsoft OLE DB Provider for ODBC Drivers”, Product Name of “Navision” and a Data Source of “Navision ODBC” (which is the ODBC system DSN). Creating this works well, and I can even view the list of tables. So I know SQL server is talking to the Navision data. I am having difficulty retrieving data. THeoretically, I should be able to use a four-part name to pull data, such as: SELECT \* FROM NAVLIVE…Department But I get the following: Server: Msg 7317, Level 16, State 1, Line 1 OLE DB provider ‘MSDASQL’ returned an invalid schema definition. OLE DB error trace [Non-interface error: OLE/DB provider returned an invalid schema definition.]. Anyh ideas would be greatly appreciated. Thanks, Ken

---

<div class="post-metadata">

**Author:** ![robertc](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@robertc](https://www.dynamicsuser.net/u/robertc)\
**Post date:** [December 1, 2004, 5:16pm UTC](https://www.dynamicsuser.net/t/problem-connecting-navison-as-a-linked-server/13331/2 "2004-12-01T17:16:45Z")

</div>

C/ODBC does not function with OLEDB for ODBC, which is what linked servers are using. There are too many different types of basic errors.

---

<div class="post-metadata">

**Author:** ![kbirecki](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@kbirecki](https://www.dynamicsuser.net/u/kbirecki)\
**Post date:** [December 2, 2004, 12:15pm UTC](https://www.dynamicsuser.net/t/problem-connecting-navison-as-a-linked-server/13331/3 "2004-12-02T12:15:28Z")

</div>

Thank you Robert. That makes sense. Does not make me happy, but it makes sense. Ken

---

<div class="post-metadata">

**Author:** ![kbirecki](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@kbirecki](https://www.dynamicsuser.net/u/kbirecki)\
**Post date:** [December 2, 2004, 1:51pm UTC](https://www.dynamicsuser.net/t/problem-connecting-navison-as-a-linked-server/13331/4 "2004-12-02T13:51:17Z")

</div>

Thanks Devi, but I don’t have the SQL version of Navision. I’m trying to use the ODBC to get access to the Navision C/SIDE data. I’m looking for any resonable means to establish a Linked Server from SQL to Navision Data, short of upgrading to Navision SQL, which is too cost prohibitive right now. Any other ideas? THanks, Ken

---

<div class="post-metadata">

**Author:** ![robertc](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@robertc](https://www.dynamicsuser.net/u/robertc)\
**Post date:** [December 3, 2004, 6:30am UTC](https://www.dynamicsuser.net/t/problem-connecting-navison-as-a-linked-server/13331/5 "2004-12-03T06:30:33Z")

</div>

Ken, It might not be practical for you, but NODBC shipped with Navision 4.0 (replacement for C/ODBC) is much improved in this area and may funciton for what you need to do.