Print Page | Close Window

Connecting to a mysql view

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16549
Printed Date: 21 Apr 2025 at 12:11pm


Topic: Connecting to a mysql view
Posted By: AdamField
Subject: Connecting to a mysql view
Date Posted: 24 May 2012 at 2:16am
Hey Guys,
 
Recently my boss desided to migrate from MS sql to MySQL.  I have the great job of fixing all our reports into the new setup.
I made all the db's and stuff needed on the mysql server itself and it seems to be working great there.
 
Now when i make a new report select the view i need i get the following error:
Error in Databaseconnector 42000 MySQL ODBC 5.1 driver
You have a error in your  SQL syntax; check the manual that corresponds to your mysql server version for the right syntax to use near 'multi filiaal where 0=1' at line 1  db error :1064
 
The view itself works perfect when i run him with navicat (view code http://users.telenet.be/Siferon/CR/view.txt - here ).
Anybody has a idee what could couse this error ? if it's mysql related or more error from CR itself.
 
All help appreciated
 
Adam


Replies:
Posted By: AdamField
Date Posted: 24 May 2012 at 4:24am
Hmm seens that i found the problem..
 
stupid  ' ' (space) behind the view name was making things go wrong
 
Adam

Posted By: AdamField
Date Posted: 07 Jun 2012 at 4:07am
Hmm Seems that i was wrong,
 
I got this working for 1 view but it keeps crashing on my other views (different db's on same server)
 
Error that i get :
The exception unknow software exception (0xc0000409) occurred in the application at location 0x07204872. 
Click ok to terminate / cancel to debug
 
both close down the program..
 
Any idees ?
 


Print Page | Close Window