Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

direct not support odbc for infobright

for ODBC CONNECT  for infobright database.

SQL SELECT AllowUsed,
    CompanyKey, PromotionCode,StartDate, StartTime
FROM `bi_psidw`.`dim_promotion`;

it is ok . but the following that appear "Error -- expected <QualifiedName>, found " `bi_psidw`.`dim_promotion`" "

DIRECT QUERY
dimension
CompanyKey
measure
    PromotionTypeCode
detail
       StartDate
     detach
       StartTime
    FROM `bi_psidw`.`dim_promotion`;

If it is SQLServer ,it is ok  because it is different 'from'.

Do the  direct discovery  support all databases using ODBC  ?

1 Solution

Accepted Solutions
Not applicable
Author

I have solve it . I must set like the following :

SET DirectIdentifierQuoteChar='``';

View solution in original post

9 Replies
Not applicable
Author

I find  it is ok for first time using SQLServer , If I reload the qvw file , it appear like this:

    ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: '0x20ef'

I am using 11.20SR6 .

Not applicable
Author

jack,

check in your database engine if there was any query sent to it from QV and if yes - how does it look like.

regards

D

Not applicable
Author

I can load data using SQL SELECT for both databases . For infobright , I change as suggested , it isn't ok . For SQLserver , the first time is ok . I reopened it that error message . What is missing in using DD ? For SQLSERVER I must set connection again .

Not applicable
Author

Maybe here you will find some tips:

Not applicable
Author

I have study the pdf . I can't find any idea . It is simple to use it . The test.qvw  can't reload  . I reinstall QV SR6 , It is the same . Are  there any settings  for DD ?

Not applicable
Author

Now I change to another computer . It is same for SQLServer . It seems this file have gone wrong .I must rebuild a new .qvw file and copy all script to it , after that ,It is ok. I think the setdirect have some problems.

Not applicable
Author

I have solved the problem in SQLServer . It is because  of  '  DirectStringQuoteChar' setting . but in mysql , I still don't solved it .

Not applicable
Author

SQL##f - SqlState: 37000, ErrorCode: 1064, ErrorMsg: [MySQL][ODBC 5.2(a) Driver][mysqld-5.1.40]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"bi_psidw.dim_stockproerty"' at line 1

----  I reload the same .qvw file in another computer . It is ok . In this computer I find

the origin script :

  FROM $(databasename).dim_stockproerty;

in wrong computer  it has been changed to :

   '"bi_psidw.dim_stockproerty"'

It have more ' quote  , how to set it disappear  ?

Not applicable
Author

I have solve it . I must set like the following :

SET DirectIdentifierQuoteChar='``';