direct not support odbc for infobright

[#1]

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  ?

[#2]

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 .

[#3]

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

[#4]

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 .

[#5]

Maybe here you will find some tips:

[#6]

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 ?

[#7]

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.

[#8]

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

[#9]

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  ?

[#10 · Accepted solution]

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

SET DirectIdentifierQuoteChar='``';