Re: NewEra programers
You're not alone in your misery -We're lumbered with NE2.12 As we needed lots of custom classes due to NE's limitations we don't even have enough time or resources to upgrade it until a lot later on. If anyone has used NE 2.x connecting to SQL Server (long story) I'd be very grateful to hear from them. (NE3.x has the functionality I'm looking for that NE2.12 doesn't - trying to find some work around - synopses of the problem at end of message) As far as changing tools goes, we've moved to VB with ADO 2 and VC++ when necessary for any new apps we design. When we get the chance we will duly upgrade to VB and ceremoniously burn the NE code. I think its a sensible option. So, you're not crying alone... John My problem: Due to legacy restrictions our New Era apps have been writing (and duplicating) data to Informix, Fox dbs. We now need to add SQL Server 6.5 to this. Problem is this. SQL Server implements page locking, not row locking and default lock mode is WAIT (NO WAIT on Informix I think) So any update I attempt on a locked row (or region near that locked row) will wait until the transaction has committed or rolled back before returning control back to my app. I wanted to set a request timeout but this is available only for Native Informix connections in v2.12 and not ODBC connections. To make matters worse, I can't even set the isolation level. When I specify dirty read (SQL_txn_read_uncommitted) I get a return code of -1. If anyone on the planet has had similar difficulties, I would love to hear from them. Thanks John Cristian Bucur wrote in message <73bot9$9su$1@news.xmission.com>... > >This is a multi-part message in MIME format. >--------------7B584FD57352426142B6B6FD >Content-Type: text/plain; charset=iso-8859-1 >Content-Transfer-Encoding: 8bit > >You are not alone! We both are alone! >I work with NE3.0, it's about a banking solution. >I'm going to change the platform in the future if NE remaines in the air... >At this moment, I can't left NE >CRISTI. >cristi@phoenix.kappa.ro > >peisa_gandia@vlc.servicom.es wrote: > >> Hi, >> I would like to know if there is anybody programming on Informix-NewEra >> all over the world. I have been thinking that I'm absolutely alone. >> I have been programming on NewEra since version 1.0. Now I am in >> NewEra 3.10 and I have heard that Informix has left this language. >> If you have programmed in NewEra an you have left it, I'm interested to >> know which language are you programming on, and what have happen with the >> programs you made in NewEra. >> >> I would really appreciate any help. >> >> Thanks in advance, >> >> Carlos Tortajada >> Valencia, Espa'a >> ctb_dir@yahoo.com > >--------------7B584FD57352426142B6B6FD >Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" >Content-Transfer-Encoding: 7bit >Content-Description: Card for Cristian Bucur >Content-Disposition: attachment; filename="vcard.vcf" > >begin: vcard >fn: Cristian Bucur >n: Bucur;Cristian >org: Informix Romania >email;internet: cristi@phoenix.kappa.ro >x-mozilla-cpt: ;0 >x-mozilla-html: FALSE >version: 2.1 >end: vcard > > >--------------7B584FD57352426142B6B6FD-- >