I would try to change the Number(11) and Float(126) to a Number. (default is about 22 I think).
What the hell do you need a float(126) for? That seems a bit over the top unless you are doing serious astro-physics. The number(11) might cause problems as it doesnt fit into a 32 bit MapInfo Integer. So try NUMBER without an argument (which has, in fact, a bigger range but MI doesnt care about that.) please let me know how you go. hth christof > Hi All, > > In MapInfo 6.5 we are trying to open a series of DBMS tables from Oracle. > > These tables originally were in an Access database, but needed to be > migrated to Oracle Personal 8i where they now "reside". > > There are 8 tables which we are trying to open (via the "Open DBMS > table" > menu item). Seven are opened without any problems, however number 8 is > having/causing some difficulties. When opening this table we get the > following error: > 'Restricted data type attribute violation.' > > The table consists of 6 columns with the following structure (according > to > DBA Studio): > Number (11) > Float (126) > Varchar2(12) > Varchar2(40) > Number(11) > Number(11) > > Does anyone have suggestions as to what might be going on here? > > Note that we can open all the tables via ODBC in Access without any > problems. > > > ___________________________ > Steven Kalma > Integrated Data Solutions > URS Netherlands B.V. > > +31-(0)70-336-9089 (direct) > +31-(0)70-319-2112 (switch) > +31-(0)6-5342-8976 (mobile) > +31-(0)70-319-1125 (fax) > > [EMAIL PROTECTED] > www.urscorp.com/europe > ___________________________ > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
