TOPIC: Database Vendor COde:1064

Database Vendor COde:1064 19 Dec 2016 20:39 #2479

  • StrataCraig
  • StrataCraig's Avatar
  • Offline
Trying to schedule a report with Logicity and getting a Database Vendor Code: 1064 error whenever it tries to run, no matter what I try to do with it.

I can run the report fine in Crystal Reports and copying the SQL statement from the report and running it in MySQL it runs fine as well.

Any ideas as to what I might be running into here?
The administrator has disabled public write access.

Database Vendor COde:1064 21 Dec 2016 15:42 #2481

  • StrataCraig
  • StrataCraig's Avatar
  • Offline
Ended up figuring this out. The report had a view in it, so I had to create a few subreports to pull the correct data and remove the view. Report worked fine after that.
The administrator has disabled public write access.