QV and db mysql

[#1]

Hello,
I would to know is if possible to connct QV to a database mysql.
I would to cnow is can I connect the QV to a aour website database based
to mysql and hosted from a Provider. I hope so and in this case how to do?

Thank you./Grazie
Best Regards./Ciao

Sl.

[#2]

Now works but not correctly.

The odbc connection do not show correctli the name of the table.. why? yhe name of table are all blank..

and the query shows something like this:

SWL SELECT

FROM ;

If in this script i correct and I force the value in

SQL SELECT *

From Products;

the table appears correctli in list box.

Now probabily the format of DB and the tables are wrong (ollation). Someone knows something abou? Could to help me?

Thanks

Best Regards, Slash

[rwunderlich]

Slash69 wrote:when I connect from QV the select table is White..

This is a known problem with the MySql 5.1 ODBC Connector. To workaround this problem, use the 3.51 ODBC Connector.

-Rob

[#4]

Hi Joachim,

You are right that the host must allow external access and database host name is needed for the connection.

If your subscription plan with the provider is web hosting and database (e.g. MYSQL) is provided, then you should be able to access and extract data.

regards,

[#5]

Yes it word!

Just problem when I set up the ODBC becouse it crashed. However I fount the way to solve this.

Thnks This solution is very good to menage, outside of php, the db.

Thanks at All and thanks QlikView!

Best Regards

Slash