Navision database, C/ODBC and SQL Server 2000

bjarvis

Could anyone help me with referencing Navision proprietary database tables from SQL Server 2000 using C/ODBC. Apologies for the essay !!

I have a 3.10 Navision installation with C/ODBC installed. The configured data source successfully retrieves information from the Navision database file for the chosen company via Access and Excel.

I have created a linked server within SQL Server 2000 using the MS OLEDB Provider for ODBC Drivers and used the System DSN previously setup (that was shown to work successfully above). The linked server successfully shows me the list of Navision tables.

My problem is then how to reference those tables through Transact SQL. Usually through linked servers you require 4 identifiers of

linked server.catalog.schema.object

however when trying (using linked server 'Test')

TEST...Company

missing out a definition for the catalog and schema I receive an error message:

Server: Msg 7317, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' returned an invalid schema definition.

and missing out the schema portion altogether

TEST..Company

not surprisingly returns

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'TEST..Company'.

as its now looking for a database called TEST.

Any help gratefully received.

ingrid

Hi;

I'm just wondering if you can help me with the linked server connection? What did you put into:

Product Name:
Datasource:
Provider String:
Location:
Catalog:

to create your linked server? I can then help you with querying the connection.