0 lines fetched

[#1]

I'm new to QV and I'm trying to connect tables from MySQL. I connect through the OLE DB option in Edit Scripts and I am able to connect to all of the tables and attributes. The problem is that my row data doesn't pull through. When I reload, it says "0 lines fetched" for each table. Thanks in advance for your suggestions!

[oknotsen]

Check if the account you are contacting the database with has the right permissions.

[Anonymous]

If permissions check out ok, could you share your load script.

[#4]

Could you elaborate on this? I'm sorry to be so ignorant, but this is new territory for me!

[#5]

Could you please explain how to do this? (Totally inexperienced!!)

[Clever_Anjos]

Please check

• Correct permissions
• Correct Database
• Does your SQL runs outside QV, using  WorkBench?

[oknotsen]

I am not a DBA, so I fear I can not help you with that.

Alternative explanation is that you have some weird "where" clause in your load script, but for that I need to see that script.

[#8]

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=C_FLAT;Data Source=PROTOCHIPS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=PROTOCHIPS;Use Encryption for Data=False;Tag with column collation when possible=False];
//-------- Start Multiple Select Statements ------
SQL SELECT *
FROM "C_FLAT".dbo."ACCOUNT_DIM";

SQL SELECT *
FROM "C_FLAT".dbo."OPPORTUNITY_DIM";

SQL SELECT *
FROM "C_FLAT".dbo."PARTS_DIM";

SQL SELECT *
FROM "C_FLAT".dbo."YIELD_FACT";

SQL SELECT *
FROM "C_FLAT".dbo."YIELD_TIME_DIM";
//-------- End Multiple Select Statements ------

[#9]

Yes yes and yes

[#10]

Just an update... When I use a dumpfile to execute the table creation in MySQL from my teammate (who is integrating in Talend), it gives me this problem. If I create the tables myself manually, then load the insert statements from the dumpfile (after opening in Notepad), I don't have this problem...! At least I figured out a workaround, but does this ring any bells for anyone?