Forum Discussion
eTribble
Advocate II
Advocate IIDM_GWPipeline_Gateway_MashupDataAccessError (Not like other post)
So I have multiple reports that pull from 1 or 2 MySQL databases, Most pull from the same database in which I get this error. The "table" at the end of the error varies. And this error is not constin...
I fixed it, it was actualy the query itself causeing it to time out. I re-ajusted the query and no more issues.
eTribbleAdvocate II
Advocate III actually use direct connections to the database through the gateway,
let
Source =
MySQL.Database("[HOST]", "[Database]",
[CommandTimeout = #duration(0, 0, 2, 0), Query = "
SELECT * FROM [Database];
", CreateNavigationProperties = false])
in
Source
It was just easier that way, would it make a difference to change them to OLE or ODBC?
Again this is only recent, been doing direct query with this reports for almost a year with no issues.
