ODBC Error: SQL5001

[DarkAngel]

I found a suggested solution to this at:

http://support.seagatesoftware.com/...126.asp?AJID=AA445CBF22308D468A82EE2F3E60334C

I made the changes to the client access settings and continue to receive the error. Do I need to recreate the report or edit the SQL statement?

I am not familiar with SQL syntax...but when I do Database|Show SQL Query...it shows:

SELECT
TABLENAME1."FIELDNAME1", TABLENAME1."FIELDNAME2",
TABLENAME2."FIELDNAME1", TABLENAME2."FIELDNAME2",
TABLENAME2."FIELDNAME4", TABLENAME2."FIELDNAME5",
TABLENAME2."FIELDNAME6", TABLENAME2."FIELDNAME7",
TABLENAME2."FIELDNAME8"
FROM
"DATABASENAME"."LIBRARYNAME"."TABLENAME1" TABLENAME1 RIGHT OUTER JOIN
"DATABASENAME"."LIBRARYNAME"."TABLENAME2" TABLENAME2 ON
TABLENAME1."FIELDNAME3" = TABLENAME2."FIELDNAME3"

If the SQL statement is correct, are there other ODBC settings I should check?

Thanks,
D.A.

 

[DarkAngel]

Forgot to mention I'm using CR 8.0.

 

[MalcolmW]

The SQL looks normal - can you run it from the Crystal Query tool? Malcolm

 

[DarkAngel]

Malcolm:

Thank you for eye balling the SQL code. I receive the same error when I run it from the Crystal Query tool. I think it may be a problem with the database. It seems that while I was out of the office last week that some of the tables became corrupted and had to be rebuilt (nice of them to tell me, ay).

I tend to babble so to make a long story short, my problem has now disappeared. How? The dba has changed the specs for the report I've been working on. Now it is based on one of the tables above and two entirely different tables.

Thanks again,
D.A.

;-)