Hi ,
I am trying to connect to Navision Attain 3.70A from Qlikview. It has a native database(.fdb) and no SQL Server database.
Followed below mentioned steps:-
1) Installed CODBC driver from Navision CD.
2) Created System DSN for Navision Database on ODBC Administrator(32 bit).
Couldn't test this connection as no feature provided for testing the connection.
3) Installed 32 bit Qlikview Personal Edition on same machine.
4) Edit Script-->Connection Wizard--> Database = ODBC--> Connect.
Selected the System DSN Created in ODBC Administrator--> Test Connection
5) It failed with a Message
Connection Test Failed
SQL##f - SqlState: S0000, ErrorCode: 4, ErrorMsg: [Microsoft Business Solutions ApS][Microsoft Business Solutions-Navision ODBC Driver]ISAM error
Tried using OLEDB--> Microsoft OLEDB Provider for ODBC drivers.....with no success.
Attached the error and some screenshots for reference.
I need to do this without using Paid connectors.
