Linked Server to Navision DB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Vitaly (anonymous_at_discussions.microsoft.com)
Date: 04/12/04

  • Next message: timjohns: "FoxPro 6.0 and ODBC" 
    Date: Mon, 12 Apr 2004 10:16:02 -0700

    Hi,
    I'm trying to connect to a Navision Database from SQL 2000.
    I installed the C/ODBC 32 bit driver provided by Navision. I created a DSN and I was able to create a DTS package to import some of the tables from Navision to SQL.
    Now I want to create a Linked Server to the same Navision DB to be able to query directly tables in Navision.
    I tried all the providers (MSDASQL,SQLOLEDB) from SQL Books Online as the @provider parameter for the sp_addlinkedserver, but it didn't work.
    Does anybody know what provider I have to use to create a linked server to Navision or how can I find it out from the registry or otherwise (maybe from the DTS package settings?).

    Thank you in advance.

  • Next message: timjohns: "FoxPro 6.0 and ODBC"

    Relevant Pages

    • Re: ADO and DELETE Statement
      ... CommitTrans, and RollbackTrans methods of the ADO connection object, SQL ... I would expect documentation for Navision to discuss transactions. ...
      (microsoft.public.data.ado)
    • Problem importing data in SQL (DTS - ODBC - Navision Attain)
      ... I have a problem with importing data in SQL. ... I'm using DTS and ODBC to connect to Navision db. ... Microsoft OLE DB Provider for ODBC Drivers ...
      (microsoft.public.sqlserver.odbc)
    • SQL Merge Replication with Navision Client
      ... I am setting up SQL 2000 Enterprise Edition SP3, using The MS Navision ... Client 3.70a as the end user client software. ... I can get replication to succeed but on 3 tables I ...
      (microsoft.public.sqlserver.replication)
    • Linked Server to Navision DB
      ... I'm trying to connect to a Navision Database from SQL 2000. ... I created a DSN and I was able to create a DTS package to import some of the tables from Navision to SQL. ... Does anybody know what provider I have to use to create a linked server to Navision or how can I find it out from the registry or otherwise. ...
      (microsoft.public.sqlserver.odbc)
    • Converting Characters
      ... Currently I'm using MS-Navision with SQL 2005. ... Navision, when I do select statements in the SQL Server Management Studio, ... those double-byte characters in the correct format. ...
      (microsoft.public.dotnet.languages.csharp)