Adding a bit more info ... the following is from Dr DeeBee Spy's log ...
SQLExecDirect
0x020A0001
[171]SELECT
"CLAIMS_CLAIMCOSTS"."CLAIM_NUMBER","CLAIMS_CLAIMCOSTS"."Z_ASSOC_ROW" FROM
"CLAIMS_CLAIMCOSTS" "CLAIMS_CLAIMCOSTS" ORDER BY
"CLAIMS_CLAIMCOSTS"."CLASS_OF_BUSINESS"
SQL_NTS
SQL_ERROR
SQLError
NULL
NULL
0x020A0001
[5]S1000
950088
[327][IBM][UVODBC][1401032]Error ID: 46 Severity: ERROR Facility:
DBCAPERR - UCI Error. Func: SQLPrepare(DML); State: S1000; uniVerse code:
950088; Msg: [IBM][SQL Client][UNIVERSE]UniVerse/SQL: syntax error. Unexpected
filename. Token was "CLAIMS_CLAIMCOSTS". Scanned command was FROM
"CLAIMS"_"CLAIMCOSTS" "CLAIMS_CLAIMCOSTS" .
512
327
SQL_SUCCESS
What's odd is it looks like it's the PC end getting the query wrong before it
sends it, but I've got two files sharing the same physical dictionary file and
one works while the other one doesn't ... which implies a data problem ... cue
headscratching here ...
Cheers,
Wol
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman
Sent: 30 June 2008 09:46
To: [email protected]
Subject: [U2] ODBC problems
I'm having a problem with ODBC ... I found a post about what looks like my
problem on gmane from 3 years ago but it wasn't very helpful ... it just said
"we upgraded our software and it went away" ...
Anyways, the error I'm getting is
ODBC--call failed.
[IBM][UVODBC][1401032]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI
Error. Func: SQLPrepare(DML); State:S10000;
uniVerse code: 950088; Msg: [IBM][SQL Client][UNIVERSE]Universe/SQL: syntax
error. Unexpected filename. Token was
"CLAIMS_CLAIMSCOSTS". Scanned command was FROM "CLAIMS"_"CLAIMCOSTS"
"CLAIMS_CLAIMCOSTS" . (#950088)
I can call up the linked table in Access no problem. As soon as I click on a
column to sort it, however, this is the error I get. My colleagues are trying
to create queries and are getting similar problems, a straight table retrieve
works fine - but as soon as they add selection or sorting criteria it starts
bombing out.
It also seems to be a bit inconsistent in that it will often work first time,
and then start failing (though that may be a false impression as we've been
playing with criteria trying to work out what works).
Software? I've loaded the latest UV clients from a 10.2 CD, I'm running Office
2003 for Access, and one of my colleagues is running Office 2007. I'm on XP.
(The previous post I mentioned talked about Crystal Reports, which we're not
using.)
Anybody got any clues as to what's wrong? Or am I just going to have to try
and update everything and hope it goes away? One thing I notice - the two
instances of the filename are differently-quoted - does that give anyone any
ideas?
Cheers,
Wol
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
