Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: Connecting to a mysql view Post Reply Post New Topic
Author Message
AdamField
Groupie
Groupie


Joined: 04 Jun 2009
Online Status: Offline
Posts: 88
Quote AdamField Replybullet Topic: Connecting to a mysql view
    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 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
IP IP Logged
AdamField
Groupie
Groupie


Joined: 04 Jun 2009
Online Status: Offline
Posts: 88
Quote AdamField Replybullet 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
IP IP Logged
AdamField
Groupie
Groupie


Joined: 04 Jun 2009
Online Status: Offline
Posts: 88
Quote AdamField Replybullet 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 ?
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.027 seconds.