Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Data Connectivity
Message Icon Topic: MySQL and Vs 2005 Post Reply Post New Topic
Author Message
Fany10
Newbie
Newbie


Joined: 30 Jul 2007
Location: Spain
Online Status: Offline
Posts: 6
Quote Fany10 Replybullet Topic: MySQL and Vs 2005
    Posted: 30 Jul 2007 at 5:28am
I am using Connector ODBC 3.51.12. When I "Configure Data Source" in the ODBC Data Source Administrator the connection tests successfully. Then I then go to Visual Web Developer 2005 Express and try to configure the SQLDataSource control. When I get to the "Configure the Select Statement" dialog everything looks fine and the Select statement "SELECT * FROM [table_name]" is generated. When I then go to the next screen and hit "Test Query" I get "ERROR [42000][MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[table_name]' at line 1".

Thank you.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 30 Jul 2007 at 2:42pm
You're probably going to get a better response asking this question in either a Microsoft or a MySQL forum.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Fany10
Newbie
Newbie


Joined: 30 Jul 2007
Location: Spain
Online Status: Offline
Posts: 6
Quote Fany10 Replybullet Posted: 31 Jul 2007 at 3:20am
Why?
this happens to me when I try to add a connection to the crystal reports. Simply it does not find the data me of the tables and it does not generate the tie report to me.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 31 Jul 2007 at 7:09am
You didn't explain that you were getting this error while working  in Crystal, hence my confusion.
 
What version of Crystal do you have?  Have you applied all of the patches?  I'm not entirely sure that the "Express" edition of Visual Web Developer will connect to reports correctly.  I know that the express editions of Visual Studio don't.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Fany10
Newbie
Newbie


Joined: 30 Jul 2007
Location: Spain
Online Status: Offline
Posts: 6
Quote Fany10 Replybullet Posted: 31 Jul 2007 at 8:40am
I have Visual Studio 2005 (SP 1) version 8  with Crystal Reports. I have applied nothing of the patches. Where can I get it?
when created a report with the assistant of Crytal Reports and I select the tables and the fields that I want, I give him to finalize and it says to me that not it can I follow the following steps: 1. Choose the data to elaborate the report - New connection - OLE DB I ACCEPT - to provider for odbc drivers - I select odbc that I have formed (dns of system) and the following error jumps to me. “The connection is not possible Details: ADO error code: 0x Source: Provider Description. Catastrophic error”
Thank you very much
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.000 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.