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/
