setting up SQL 2000 linked server-Navision Financials ODBC

ingrid
ingrid Member Posts: 9
edited 2004-05-24 in Navision Financials
I'm trying to create a linked server in MS -2000 to Navision Financials proprietary DB through ODBC. Can someone tell me how to do this?

What is the provider string?
Should the location be UNC? (not sure what to put here, the path is on the server somewhere.)

Thanks!

Comments

  • Ron
    Ron Member Posts: 9
    Hi,
    you need the OLE DB Provider for ODBC.
    I use only the Databasesource name for the connection.
    I can see all tables but it seems that there is now way to create a connection for a query. Invalid Schemata .
  • ingrid
    ingrid Member Posts: 9
    I beleive that the database and tables have to be referenced with brackets in order to query from another database.

    [Navision Link].dbo.["Job"]

    By the way, we got our linked server up and running, however, we can only see the Navision tables directly from the SQL server. I cannot see it from my desk through Enterprise Manager. Any ideas?
  • Ron
    Ron Member Posts: 9
    :cry:
    No way !!!

    Navision Link name : NAVISION
    Databasename: test

    From database "test" I set the statement:

    select * from [NAVISION].dbo.["item"]

    Error: Invalid Objectname

    Whats wrong? Configuration Error in my Sever?

    I use SQL2000 and C/ODBC 3.7


    Ron

Categories