MS SQL Server ODBC - Problems importing data with ODBC Navision Attain 3.6

Author

Problems importing data with ODBC Navision Attain 3.6

Hans

2005-05-26, 3:23 am

Hello,

I have problems to import data from Navision Attain into SQL Server
2000.
To import data we use DTS and for the connection to the Navision db we
use ODBC.
Two problems:
1. In the DTS-wizard step ‘Select Source Tables and Views’ when I select
the table ‘Contact’ the displayed fields are not equal to the same table
displayed in Navision. When I click ‘Preview’ no records a shown.
2. When I select an other table e.g. ‘Item’ and go through the wizard I
get an DTS import/export error: "Column names must be unique. Column
‘xyz’ is specified more than once". Looking in Navision the column names
are unique!
Starting Microsoft Access and linking a table with the same ODBC most of
the tables are displayed twice, and some three or four times. Choosing a
table I get the error message: "Cannot define field more than once".

Back to SQL/DTS:
Not all tables perform errors when importing them.

Some system/software info:
Navision: BE 3.60
OS Servers (Navision db & MS SQL Server): Windows 2000
CODBC version: 3.60.0.11353
MDAC on SQL Server: 2.7?

Can you please help me solving this problem?

Hans

*** Sent via Developersdex http://www.droptable.com ***

Sponsored Links