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!

[Clever_Anjos]

you said you´re retrieving data from a MySQL database but your script seems to be to a MS SQL Server database script, am I getting crazy?

• Your connection string seems to be a MSSQL Server database string
• Your tables have *.dbo.* schema that seems to be SQL Server tables

[Peter_Cammaert]

When you create/load the table&data with your teammate account, do you then grant the necessary permissions to your own account?

In every RDBMS, you have to specify who is allowed to access which tables and what they can do with them (SELECT,INSERT,UPDATE etc.)

Peter

[Peter_Cammaert]

Clever,

I had the same idea in another discussion where the CONNECT string and various other properties made me think a poster was accessing a SQL Server DB, while he kept denying he used anything else than a MySQL db.

I still haven't figured out what was the cause of this confusion... Maybe the MySQL driver developers decided to use the exact same names and connection properties as those used for a SQL Server DB?

Peter

[Clever_Anjos]

I´m not familiar with MySQL databases.

Maybe stefanie.boros‌ you should try Qlik ODBD driver Connectivity - New SFDC and ODBC Connectors

[#6]

I'll look into this. I apologize for being confusing - I'm still new to this and I guess I was using the wrong terminology!  I am using Microsoft SQL Server Management Studio.

Thank you all for your input!

[#7]

So sorry - yes, I am using Microsoft SQL Server Management Studio. I am new to this so I am not sure on the terminology! I did try connecting through the ODBC but was unsuccessful. As I said in another reply, I am able to make it work if I create the tables myself (instead of using my teammate's dump file) and then insert the data. Looking into if the dump file needs permissions... Thank you all for your input!