Re: VB, MyODBC, MySQL problems

[Peter Carter]

I created a site to help with these sorts of problems. It is an online VB
code wizzard for MySQL. It uses existing MyODBC and ADO/RDO.

Yes, it's free...... ;)

http://www.pbc.ottawa.on.ca

At 08:04 AM 6/28/99 -0700, you wrote:
>[posted to USENET, I hope somebody here can help me, too... :-) ]
>
>I've developed a rough prototype app using MySQL/Linux with MyODBC on NT
>using an Access/VBA front-end.  It works pretty well, but I've run into
>limits as to what I can do with Access, so I've been moving into a VB
>development mode.  Unfortuately, no matter what I try I can't seem to get VB
>to write to my database.
>
>I've been using ADO, but getting "Insuficcient base table information"
>errors when I try to do a RecordSet.Update call.  MS has this article on the
>problem:
>http://support.microsoft.com/support/kb/articles/q190/1/08.asp, saying that
>I basically need to use server-side cursors or straight-through SQL.  Well,
>I can't seem to get server-side to work with MyODBC (I think it's not
>supported yet), and straight-through SQL was giving me fits since some of
>the fields I'm updating contain large blocks of HTML code, and I'd get SQL
>errors.
>
>I've even tried reverting to RDO or DAO, but still have cryptic error
>messages that don't really help me out, and I still can't get the update to
>happen.
>
>I've seen a lot of conversation here, but not much good advice about how to
>make this work.  I've also seen a couple people claiming to have things
>working great, but I've been unable to get through to them in email... Does
>*anyone* have any good suggestions or magic answers on this one?  I'm about
>at the end of my rope, and am considering (<gasp!>) moving to an all-MS
>solution, including IIS, MS-SQL, ASP, and NT (to replace Apache, MySQL, PHP,
>and Linux).  I'd rather not do this... :-(
>
>I'd really like to get ADO working "seamlessly" (that is, like all the
>examples say), but if I have to, a method using straight SQL commands is
>good, too...anything to avoid having to re-engineer my entire back-end...
>
>Thanks!!
>
>david.
>
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail myodbc-thread356@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail myodbc-unsubscribe@stripped instead.
>
>
---
Peter B. Carter (peterc@stripped)
Pager: 613-751-4660
http://www.pbc.ottawa.on.ca

Flames are a waste of cyberspace, don't bother.......