Hello Everyone, Still having problems with autonum tables and Tango. The row is inserted but the Autonum column is null ..................................................................................................................... Error An error occurred while processing your request: File: Quotes.taf Position: InsertPrtPRD Class: DBMS Main Error Number: 2110 [RBTI][Oterro ODBC Driver][VFIMdrBASE] Resources required by command are not available. S1000 File: Quotes.taf Position: InsertPrtPRD Class: Internal Main Error Number: -101 General error during data source operation. .......................................................................................................... In another area of my application the row failed creation (I believe due to the no null in the PK constraint) where autonum is used. The web page generates the following messages: ........................................................................................................................................ Error An error occurred while processing your request: File: users.taf Position: Insert Class: DBMS Main Error Number: 2227 [RBTI][Oterro ODBC Driver][VFIMdrBASE]Value for SYSiLoggedID cannot be null. 23000 File: users.taf Position: Insert Class: DBMS Main Error Number: 2110 [RBTI][Oterro ODBC Driver][VFIMdrBASE] Resources required by command are not available. S1000 File: users.taf Position: Insert Class: DBMS Main Error Number: 2110 [RBTI][Oterro ODBC Driver][VFIMdrBASE] Resources required by command are not available. S1000 File: users.taf Position: Insert Class: Internal Main Error Number: -101 General error during data source operation. ............................................................................................................ I turned on the ODBC tracing on but the log file was never created. I disconnected everything to the database except the Tango service and condition did not change. I shut down the NT server and afterward everything is working. The ODBC tracing file is created and working. I will be leaving it on and will check it if it fails again. I have been very busy doing developmental work on the system. I do not know if the failure was triggered by my developmental work or simple the OtV2.5 has not address the issue with autonum tables. If this continues I will have to invest a lot of time to create a workaround system to simulate autonum. Before I do this I want to ask a question to the group in Tango land. Am I the only fool using autonum tables with Tango 2000? Go ahead be brutal and let me know. Thanks, Manuel "A. Razzak Memon" wrote: > Manuel, > > I would suggest to turn on SQLLOG Trace for detailed -ERROR- message > along with the syntax created by direct DBMS action in R:Tango 2000. > > Let me know. > > Good Luck! > > Very Best Regards, > > Razzak. > > At 12:14 PM 9/18/01 -0700, Manuel de Aguiar wrote: > > > >General error during data source operation. > > > >I also tried using the TANGO DIRECT DBMS with the same > >negative results. > > ===================================-============================ > Official R:BASE List Server: mailto:[EMAIL PROTECTED] > RBTI Events/Training: http://www.rbase2000.com/events > R:DCC Members: http://www.rbase2000.com/rdcc > ================================================================ > R:BASE, Oterro & R:Tango are registered trademarks of RBTI. > ==================================-=============================
begin:vcard n:de Aguiar;Manuel tel;fax:(323)661-7698 tel;work:(323)660-3511 x-mozilla-html:FALSE url:http://www.mdenterprises.net org:M|D Enterprises adr:;;2412 No. Commonwealth Avenue;Los Angeles;California;90027-1206;USA version:2.1 email;internet:[EMAIL PROTECTED] title:Developer note;quoted-printable:The information contained in this e-mail may be privileged, confidential,=0D=0Aand protected from disclosure. If you are not the intended recipient, you=0D=0Aare hereby notified that any dissemination, distribution or duplication of=0D=0Athis communication is strictly prohibited. If you have received this=0D=0Acommunication in error, please notify the sender immediately and delete all=0D=0Acopies.=0D=0A=0D=0Ahttp://www.mdenterprises.net=0D=0Ahttp:/www.databasedeveloper.com=0D=0Ahttp://www.MdrBASE.com=0D=0A x-mozilla-cpt:;-1 end:vcard
