Linked Tables and ODBC

[#1]

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?

[#2]

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

[tresesco]

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.

[#4]

Hi Tresesco,

I am connecting via ODBC to a SQL Server databse.

[#5]

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.