Tom Bolton
tom.bolton at donnslaw.co.uk
Mon Feb 7 08:40:29 CST 2005
Hi Mark Sorry, have been murderously busy for last few days - needless to say Informix was at the bottom of all my woes. This is an unusual error, one which I have no answer for. I know that there are a good number of property settings possible in the conn string - maybe one of these has gone awry? It would appear that the drivers are misinterpreting the 0 in your query string as a null character or something? Sorry I can't be of more help... Tom -----Original Message----- From: Mark A Matte [mailto:markamatte at hotmail.com] Sent: 07 February 2005 14:28 To: accessd at databaseadvisors.com Subject: RE: [AccessD] Data from Informix to Access - dirty reads? Hello All, Any feedback on this last post? Thanks, Mark >From: "Mark A Matte" <markamatte at hotmail.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: accessd at databaseadvisors.com >Subject: RE: [AccessD] Data from Informix to Access - dirty reads? >Date: Thu, 03 Feb 2005 14:39:12 +0000 > >Hello Everyone, > >Thanks for all the feedback. I'm still a little lost on this one. Here is >the current status: > >2 seperate machines: >Machine1 >NT >A97 > >Machine2 >2K Server >A97 >A2K > >Machine1 will loop through the records...but will crash when the caseID >ends in '0' . When I use the SQL "SELECT case_id from ps_rc_case WHERE >case_id<100" and loop through the case_id...I crash on 10...if I select >11 >it crashes on 20. If I loop though a different field(text fields) "SELECT >Name_First from ps_rc_case WHERE case_id<100" and loop through >Name_First...it works fine...but I need the case_id. > >Machine2 (using A97 or A2k) with the same code will loop through the >records without errors...except 10 returns as 1, 20 as 2, 25460 as 2546, >etc. > >So something is going on with both machines when the number ends in '0'. > >A suggestion from a friends was:"SELECT substr(case_id,1) as ttt from >ps_rc_case WHERE case_id<100"...and loop through 'ttt'. This actually >works on both machines...I'm just not sure why. > >Finally...the whole reason behind the original question was 'whats the >fastest way to get data from an Informix db to a local Access db'? I had >never used ADO...and was using Append queries from a linked Informix table >to a local temp table. Now that I have the recordset...whats the most >efficient way to get it into my temp table? > >Thanks Again, > >Mark > > > > >>From: Jim Lawrence <accessd at shaw.ca> >>Reply-To: Access Developers discussion and problem >>solving<accessd at databaseadvisors.com> >>To: "'Access Developers discussion and problem >>solving'"<accessd at databaseadvisors.com> >>Subject: RE: [AccessD] Data from Informix to Access - dirty reads? >>Date: Thu, 03 Feb 2005 03:52:04 -0800 >> >>Hi Tom: >> >>You may be right as I have never used a 'read-only' recordset but by >>setting >>the recordset to 'static' will give the same features and superior >>performance....Second only to 'forward-only'. >> >>Jim >> >>-----Original Message----- >>From: accessd-bounces at databaseadvisors.com >>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tom Bolton >>Sent: Thursday, February 03, 2005 2:11 AM >>To: 'Access Developers discussion and problem solving' >>Subject: RE: [AccessD] Data from Informix to Access - dirty reads? >> >>Jim >> >>If the cursor lock type is set to read-only, you can still scroll through >>it >>but will raise an error if you try to edit it. >> >>The ability to read through the cursor depends on it's type - you can read >>through all of them, apart from a forward-only cursor where as the name >>suggests you can't scroll backwards i.e. rs.MovePrevious, rs.MoveFirst. >> >>Cheers >>Tom >> >> >> >> >>-----Original Message----- >>From: Jim Lawrence [mailto:accessd at shaw.ca] >>Sent: 03 February 2005 06:03 >>To: 'Access Developers discussion and problem solving' >>Subject: RE: [AccessD] Data from Informix to Access - dirty reads? >> >>Hi Mark: >> >>If you set the recordset to read-only (adLockReadOnly) how do you expect >>read through the recordset. Try something like: >> >>rsRecordset.Open strSQL cnConnection, adOpenStatic, adLockOptimistic >> >>HTH >>Jim >> >>-----Original Message----- >>From: accessd-bounces at databaseadvisors.com >>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte >>Sent: Wednesday, February 02, 2005 10:59 AM >>To: accessd at databaseadvisors.com >>Subject: RE: [AccessD] Data from Informix to Access - dirty reads? >> >>Thanks for the feed back...but it didn't change anything. Something else >>I've noticed...I can use the same SQL criteria, except select a different >>field and I can loop through those records without a problem...it just >>occurs when I try to display or reference the case_id when it is more than >>2 >> >>digits? >> >>I'm thoroughly confused at this point...and once I get it to loop through >>the recordset...How do I get the recordset into a local/temp table? >>Although...without the case_id...the last questions doesn't really matter >> >>Thanks, >> >>Mark >> >>-- >>AccessD mailing list >>AccessD at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/accessd >>Website: http://www.databaseadvisors.com > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- The contents of this message and any attachments are the property of Donns Solicitors and are intended for the confidential use of the named recipient only. They may be legally privileged and should not be communicated to, or relied upon, by any other party without our written consent. If you are not the addressee, please notify us immediately so that we can make arrangements for its return. You should not show this e-mail to any person or take copies as you may be committing a criminal or civil offence for which you may be liable. The statement and opinions expressed in this e-mail message are those of the writer, and do not necessarily represent that of Donns Solicitors. Although any files attached to this e-mail will have been checked with virus protection software prior to transmission, you should carry out your own virus check before opening any attachment. Donns Solicitors does not accept any liability for any damage or loss which may be caused by software viruses...