Re: [U2] ODBC Error: State = S1000 Error = [Ardent][Unidata ODBC Driver][IBM][SQL Client][Unidata]Unidata lower level function error with fetch
In message [EMAIL PROTECTED], Kevin King [EMAIL PROTECTED] writes Any ideas what this message means? ODBC Error: State = S1000 Error = [Ardent][Unidata ODBC Driver][IBM][SQL Client][Unidata]Unidata lower level function error with fetch S1000 - nasty ... I'm assisting with connecting Unidata to UPS WorldShip and while the configuration in Worldship looks spot on, and we've tested the ODBC connection successfully with Excel (on that machine), this error pops up when trying to get WS to retrieve info from Unidata. I've put in a call to support, but while I'm waiting I figured someone here might have some ideas? Support probably won't be much help, initially at least. What is the SQL command being sent to WS? I've got a UV support call in that's similar. In my case, the SQL command being sent (by MS Access) is SELECT * FROM TABLE TABLE ORDER BY ... Note the doubled-up file name - UV barfs on it and you get an error S1000 back. Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] uniobjects help needed!
In message [EMAIL PROTECTED], doug chanco [EMAIL PROTECTED] writes Hey, We are having a problem with uniobjects that started a couple of days ago. We have a VB app that uses uniobjects to access an aix system running universe 10.1 and a few days ago we started getting errors where uniobjects would just die, its starting to look like it might be a network issue but so far nothing we can discover. Our Cisco guy is not seeing any errors in the cisco switches, I am not seeing any errors on the aix system (5.2.6). While is may or may not be a universe/uniobjects issue, so far we have been stumped as to what the problem is. We even called an IBM uniobjects engineer for several hours and he could not find a problem as neither could our VAR or IBM tech support for aix. So I thought I would throw this out to youll who vast knowledge may hold the key to the answers we seek! The fact that in the past 3 days I have works close to 60 hours is a testimony to the amount of effort we have been putting in to try and solve this problem. Basically what we are seeing that is Run-TIme error '-2147417848 (80010108)': Method 'Read' of object 'IUniFileEx' Failed So any suggestions/thoughts/ideas/crystal balls/magic spells/voodoo chants are welcomed! This, I think, will fall into the Voodoo Chant school of hopeful wishing ... but the message number looks vaguely familiar to me. Do you know which line of your code is returning your error? What happens if the code just retries the read? The problem I'm thinking of that we had was our program talking to Word. Word would go to sleep and you'd get an error looking a bit like that. Retry, Word would have woken up, and it was fine 2nd time. Try trapping the error and retrying, and see what happens... Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] fixtool
Hey all, is fixtool the best way to repair a universe file? I read somewhere that all it does is fix the broken link (fixing the file but losing the data that the broken link pointed to). The reason I ask is that we had data corruption a few days ago and are now running into lots of uniobject errors. When we upgrade to the latest version of uniobjects things improved a lot (which is a question in of itself as to why) but I am wondering if we are now experiencing logical errors in that our code is chunking because it cannot find certain customer info that lives in another files (this is one example of what we are seeing) if running fixtool -fix is not the best way to fix a universe file can someone shed any light on a better way? thanks again! dougc ps if it matters we are running universe 10.1 on aix 5.2 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/