Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Linked Tables and ODBC

Hi,

Introduction

  • Looking for some advice and help around Linked Tables base don ODBC Fact tables
  • Found a great document on CONCATENATE AND LINK TABLES (Mar-13) but cannot seem to get it to work.

Background

  • I am importing two FACT tables (via ODBC) into QlikView (PE) and cretaing a KEY using the common fields in the two tables;
  • I am then running some code to create the linked table but get an error message saying;
  • Cannot open file 'C:\Documents and Settings\........<FILE PATH HERE> ...........' The system cannot find the file specified.

Question

  • When I import the fact tables via ODBC where are they stored?
  • Why can the Linked Table code not find them?
Tags (1)
4 Replies
Not applicable

Re: Linked Tables and ODBC

HI,

   Are you using the ODBC connection String from any file external .

The error is due to the File which is referred in the Application but not able to locate it.

Regards

Yusuf

MVP
MVP

Re: Linked Tables and ODBC

it seems that it is nowhere related to Linked Table Code. it has to be something to do with physical location of your data source. May be the way you are trying to connect to the data source is not right. What is your data source?

Thanks.

Not applicable

Re: Linked Tables and ODBC

Hi Tresesco,

I am connecting via ODBC to a SQL Server databse.

Not applicable

Re: Linked Tables and ODBC

Hi Yusuf,

The ODBC connection details are (Details changed for privacy);

ODBC CONNECT32 TO [USER;DBQ=PROD] (XUserId is 123, XPassword is 123)

These details preceed the fact table load statement.