well - that sounds strange... I assume your server is licensed correctly, right?
- is there something in the ODBC driver settings that restricts the amount of the retrieved data? - do you always retrieve the same amount of data - e.g. always 2000 entries... - yes, ODBC is an API client and uses the login permissions Thanks Regards Rüdiger >________________________________ >Von: Alberto M. Lopez <[email protected]> >An: [email protected] >Gesendet: 13:51 Montag, 23.September 2013 >Betreff: Re: ODBC driver (MS Access) doesn't show all the records > > > >** >Hallo einmal! :-) > > >Answering your questions: > > >Remedy ODBC > >I'm using the regular form BMC.CORE:BMC_BaseElement (i need common attributes >of many classes). >All the CIs are in BMC.ASSET >I'm using appadmin (with full access). I see this CIs with user client >(7.6.04) and web client with the same user. Because odbc are the same >characteristics referring to permissions, It must work...doesn't it? > > >Thank you very much!!!!! > > > > > > > >2013/9/23 Rüdiger Tams <[email protected]> > >** >>Hi Alberto, >>Bitte sehr. :) >> >>Just to understand/be sure: >>Are you using the Remedy ODBC driver or the ORACLE ODBC driver? >> >>When using Remedy ODBC driver: >>In Access - do you use the form AST:BaseElement or BMC.CORE:BMC_BaseElement >>to query for data? >>Are all expected CIs already in the productive dataset BMC.ASSET? >>Are you running Multitenancy? >>Are you using a login that has sufficient permissions? >> >> >> >>Thanks. :) >> >>-- >>Mit freundlichen Grüßen >>Rüdiger Tams >> >> >>Von: Alberto M. Lopez <[email protected]> >>>An: [email protected] >>>Gesendet: 12:27 Montag, 23.September 2013 >>>Betreff: Re: ODBC driver (MS Access) doesn't show all the records >>> >>> >>> >>>** >>>Hi Rüdiger! >>> >>>First "danke schön" for your quick answer. >>> >>>No, the value is "0" so there is no limit. It's strange because I'm sure >>>that the data are in the CMDB (I've did a report and I have a .csv file with >>>the data (name) of BMC_CORE_BMC_BaseElement and in Access I've joined this >>>field with a linked odbc table (the same BaseElement) and I have no result. >>>:-( >>> >>>Thank you very much again! >>> >>> >>> >>>2013/9/23 Rüdiger Tams <[email protected]> >>> >>>** >>>>Hello Alberto, >>>> >>>>are you sure that there is no server side restriction regarding the data >>>>retrieval? >>>>e.g. Max-Entries-Per-Query: 10000 >>>> >>>>Regards >>>>Rüdiger >>>> >>>> >>>>Von: Alberto M. Lopez <[email protected]> >>>>>An: [email protected] >>>>>Gesendet: 10:54 Montag, 23.September 2013 >>>>>Betreff: ODBC driver (MS Access) doesn't show all the records >>>>> >>>>> >>>>> >>>>>** >>>>>Hi all! >>>>> >>>>> >>>>>I have a issue with the odbc driver when I work with MS Access. >>>>> >>>>> >>>>>I want to extract some data of the CMDB (8.1), MS Access doesn't show all >>>>>the results and I'm sure that the data I want to show are in the CMDB. >>>>> >>>>> >>>>>Anyone knows restrictions or similar with ODBC?. >>>>> >>>>> >>>>>Why I have not the data in Access?. >>>>> >>>>> >>>>>Thank you very much in advance!!!! >>>>> >>>>> >>>>>Alberto_ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>> >>>>>_ARSlist: "Where the Answers Are" and have been for 20 years_ >>>_ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >>> >>_ARSlist: "Where the Answers Are" and have been for 20 years_ >_ARSlist: "Where the Answers Are" and have been for 20 years_ > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
