Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Can't get SQL code to work Post Reply Post New Topic
Author Message
adamlange
Newbie
Newbie


Joined: 06 Apr 2007
Online Status: Offline
Posts: 4
Quote adamlange Replybullet Topic: Can't get SQL code to work
    Posted: 06 Apr 2007 at 2:10pm
When I try to create any query in Crystal Reports 11, I get an error!
 
Here is an example:
 
Select person.id
from person_tbl as person
 
Here is the error that I get:
 
Error in compiling SQL expression:
Database Connector Error: '42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keywork 'Select'.
[Database Vendor Code: 156].
IP IP Logged
adamlange
Newbie
Newbie


Joined: 06 Apr 2007
Online Status: Offline
Posts: 4
Quote adamlange Replybullet Posted: 08 Apr 2007 at 10:26am
Does anyone have any ideas on this?  Does anyone know where I can find good tutorials on how to use SQL in Crystal Reports?
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 08 Apr 2007 at 11:22am
You say that you get this error for ANY query you enter. Thus, that tells me that it isn't the SQL syntax which is the problem. Does it work when you you the Database Expert and it creates the SQL? Your SQL here looks fine. Sounds like maybe you have a corrupt SQL ODBC DLL?
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
jjcyeshua
Newbie
Newbie
Avatar

Joined: 22 Mar 2007
Location: United States
Online Status: Offline
Posts: 30
Quote jjcyeshua Replybullet Posted: 31 Aug 2007 at 3:08pm
How can you check if that file is corrupt. Is there a way around it.? Thanks
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.016 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.