setting up SQL 2000 linked server-Navision Financials ODBC

ingrid

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!

Ron

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

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

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