, ,

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

CS ODBC error .. Help (OpenInsight 32-Bit)

At 21 MAY 2002 06:21:07PM [email protected] wrote:

Working against MySql on Win2k ..

I have 'selected' approx 4500 rows and then convert change one field and update back .. Approx every other row fails.

My guess is that this is something to do with the odbc drivers .. though I am not sure of that.

I have done very large bulk inserts against Mysql from other tools and have not had any problems .. so I am trying to get some Idea as to what is happening here.

Ideas are appreciated

Thanks

[email protected] onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

Phone: 503-639-4240

At 21 MAY 2002 06:45PM [email protected] wrote:

1) The original message did not copy across completely from the Open Site .. I am getting an error 7 and 42000.

2) The 42000 error *seems* to be update/insert errors due to the data .. some of the items have a ' internal to the data which is throwing things off.

The Error 7 is still an oddity ..

I am changing file names .. so I select all the rows with file names starting with e:

select filename from songlist where filename like 'E:%'

The first pass this might return 1000 rows. The update process then simply swaps the e: with a g:

But during the loop it only completes approx every other one. If I then repeatedly do the process it select fewer and fewer and updates them (every other one …)

This is very like a binary search .. but in reverse

Still looking for ideas ..

Thanks

[email protected] onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

Phone: 503-639-4240

At 21 MAY 2002 07:51PM Pat McNerthney wrote:

David, 

There was a recent bug fix in the Data Set stuff.  Make sure you are using the latest 4.02 download.  Maybe Mike can clarify if that latest download has that fix, I believe it does.

Pat

At 21 MAY 2002 11:29PM [email protected] wrote:

Pat,

Thanks for the response ..

I am using the xo stuff not dataset (should have mentioned that).

I am very sure that it is some kind of timing issue in that I put a 10 second 'wait' into the update loop and the number of errors decreases. Of course this does make it unusable

It is so odd that MySql has had no problems with bulks OR with a Delphi application I am using .. pumps in as fast as I send it

[email protected] onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

Phone: 503-639-4240

View this thread on the Works forum...