>>>>> "Steve" == Steve Freitas <sflist@stripped> writes:
>> Not necessarily MyODBC -> MySQL, but something is wrong with the setup
>> of iHTML -- check the docs on iHTML to see how to extract error
>> messages -- the worst thing is to have something not work and not get
>> any error message at all.
Steve> Yeah, I know the feeling. iODBC is such a piece of crap that way. When an
Steve> occurrs, it's always a "350" error with no other clues.
Steve> Back to the subject though. I don't think there's anything wrong with
Steve> iHTML, for two reasons. First, I did check and there was no error
Steve> generated. Second, when I reverted back to an earlier version of MyODBC,
Steve> the query worked with no iHTML modifications whatsoever.
Steve> Is there a way I can do queries from the command line through MyODBC?
Yes.
In the libiodbc source distribution you can find programs for this in
the 'samples' directory. The newest MyODBC distribution even gives you a
full example of this in the INSTALL file.
Regards,
Monty