Successfully I have created reports using an SQLLITE DB but am having trouble trying to do the same with my remotely hosted MySQL DB.

I have tested the connection all its all good

After creating the dateset (xsd), on server explorer highlighting a table to place (drag) on to my xsd I get a strange error which I dont understand.

Name:  A3.jpg
Views: 128
Size:  13.8 KB

Name:  A1.jpg
Views: 116
Size:  19.0 KB

Name:  A2.jpg
Views: 100
Size:  23.3 KB

The table does not 'transfer' to the dataset....I have tried everything but cant work out why.

1) Closed the connection
2) Opened the connection
3) Re connected.

Just to emphazise my DB is hosted remotely and I am able to read and write without a problem.

Can anyone help please