Posted by Tom Fulton on September 17, 2004 at 05:37:51:
In Reply to: Re: ODBC problem posted by Grant Foraker on September 16, 2004 at 13:16:27:
In your map setup define the fields with a leading "EmplVaca." and
give it a try. Let me know the results. We're using MySQL and everything worked fine when first set up. A while ago a release came
out that made all our ODBC apps generate the excp 29 ( you have to do
a lot of excp trapping to actually find out what the real error is ).
We did the digging and found that it was and undefined field. Adding
the DSN name as a prefix followed by the dot fixed the problem. I talked to Brian about it and he said he had modified the workings for
an end-user with a problem and hadn't expected this end-result. He gave us a version that essentially backed that code out so we're back
to just our field names. But I believe the version that's included in
the release may require the leading DSN name. I'll Email you the version that does not require the leading DSN name and you can try that. Tom.