ODBC Error SQLPrepare Syntax Error #7274516 (OpenInsight 32-Bit)
At 18 JUN 2008 12:36:15PM John Bouley wrote:
Error is displayed while trying to view a small table from within Microsoft Access 2003. Dictionary is visible but no data.
Any ideas?
Thanks,
John
At 18 JUN 2008 05:00PM Bob Carten wrote:
John,
That error was common with early versions of the ODBC driver. We did some work ( in a program named REVODBC_GROOM_SQL ) to resolve that problem. Email Sean the date of your ODBC dll, I think he can tell you if you have an earlier version.
You can watch what is occurring if you turn tracing on in the ODBC administrator, then look at the trace file to see the string sent to OI from ACCESS. In OI, EXEC SQL ( I think we shipped it ) you should get a window where you can paste the SQL, see the issues. The problem arose because Access tries to create fully qualified descriptors like SELECT "MYDATABASE"."MYTABLE"."MYCOLUMN" FROM "MYDATABASE"."MYTABLE"
The excess formality confused REV_SQL. The fix had to do with stripping out excess quotes and other formality till the statement runs in OI, then getting MSACCESS to pass thru the exact SQL you want.
- Bob
At 18 JUN 2008 05:43PM John Bouley wrote:
Bob,
I did look at the SQL and it is fully qualified. I did look at the version and it appeared to be the latest althouh I am not sure what version is the latest.
john
At 19 JUN 2008 11:04AM John Bouley wrote:
Ok still waiting for the version on the dll but I found the version of REVODBC_GROOM_SQL. (13591.7548958333) that translates to 3/17/05 18:07.
I also tried some sample SQL and it worked fine. The only difference I could see from Access and what I entered was the table name included the account. Could this be causing the problem?
John
At 19 JUN 2008 11:49AM John Bouley wrote:
FYI, the RevODBC.dll is dated 04/16/04.
Thank you,
John