topic Re: Re: Re: direct not support odbc for infobright in QlikView

direct not support odbc for infobright

Sat, 17 May 2014 10:34:44 GMT

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 ?

Re: direct not support odbc for infobright

Sat, 17 May 2014 14:04:46 GMT

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 .

Re: direct not support odbc for infobright

Sat, 17 May 2014 14:10:04 GMT

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

Re: direct not support odbc for infobright

Sat, 17 May 2014 14:23:55 GMT

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 .

Re: Re: direct not support odbc for infobright

Sat, 17 May 2014 14:31:33 GMT

Maybe here you will find some tips:

Re: Re: Re: direct not support odbc for infobright

Sat, 17 May 2014 15:05:43 GMT

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 ?

Re: Re: Re: direct not support odbc for infobright

Sat, 17 May 2014 15:40:37 GMT

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.

Re: Re: Re: direct not support odbc for infobright

Sun, 18 May 2014 01:42:46 GMT

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

Re: Re: Re: direct not support odbc for infobright

Sun, 18 May 2014 09:24:29 GMT

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 ?

Re: Re: direct not support odbc for infobright

Mon, 26 May 2014 14:53:36 GMT

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

SET DirectIdentifierQuoteChar='``';