I was able to get it to work when I went back to an earlier release of ODBC clients. This older release will prompt for the location of the ODBC Server which defaults to /usr/uv. Our system configuration has the ODBC Server at /u1/uv. The newer release of ODBC Client does not prompt for this ODBC Server location.
My next dilema is in updating the data. >From Microsoft Access 2003, I am able to pull data from a Linked Table >accessing Universe Data. However, when I try to update a piece of information it takes a long time to think and eventually comes back with the Following Error: ODBC - Update on Linked Table "PARTS" failed. [ARDENT][UVODBC][1401030]Error ID: 3 Severity: FATAL Facility DBCAPPERR Could not login to Database /live8/TEST.ODBC as user root. (#0) My ODBC Connection String Login Name is not root so I don't know why it mentions root in this error message. Also Tried logging in as root and rootuv to no avail either. Any Help with this would be greatly Appreciated. Thanks, John ________________________________ From: Brian Leach <[email protected]> To: U2 Users List <[email protected]> Sent: Tuesday, September 15, 2009 2:02:19 PM Subject: Re: [U2] ODBC Connection Error Hi John Unfortunately that error just means an RPC connection error, which doesn't give much to go on.. Any context you can provide for this? Brian > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of > John Castilletti > Sent: 14 September 2009 16:26 > To: [email protected] > Subject: [U2] ODBC Connection Error > > Can someone shed some light on what may be wrong with my > attempt at connecting to A Universe File from MS Query using ODBC. > > The error is: > Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. > Func:SQLPrepare(DML); State: IM985; universe code; 81002; > Msg: [IBM][SQL Client][RPC] error code - 81002. > > Thanks in Advance > > John > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
