Hi Rüdiger, where could I set the ODBC settings?. And not, I have no problem in the retrieval....If I set this to 0 I get all the results (more than 2000) but not all.
If you could tell me where could I set the ODBC settings would be perfect!!!! Danke!!! 2013/9/24 Rüdiger Tams <[email protected]> > ** > 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_ > > > _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"
