>I am new to dababases in general and have a few questions. I have been >building a database in mysql using sql commands in msdos but would like >to use Visual Basic from here on out to edit the database. After >completion of the database I need to use it for a program that will also >be editing the database automatically. >I need to know: >-at least one way to connect to the Mysql database with VB6 Just use ADO if you're familiar with it. You can use either and ODBC connection or an OLEDB provider. Personally, I've had more success with the ODBC provider.
>-what commands I can use in VB6 to access and edit the database (or a >site that will point out how to use the commands) Again, if you know ADODB, you're all set. >-can I use an SQL book for reference on commands The MySQL website is very good for commands, otherwise to find some sample code using ADODB, I'd head to: http://www.planetsourcecode.com/xq/ASP/lngWId.1/qx/vb/default.htm >Also, I am only a senior in high school writing all of this code, so try >to keep it on a level where a 3rd year Comp Sci student could >understand. I know this is asking a lot but I am part of a group of >students putting together a program and I am the only one around doing >the database so I have no one to turn to except the internet and >searching through the archives is the only help I have had so far. Any >help with any of those questions is much appreciated. Thank You > >Joe Bradbury >Allen High School Senior > >---------- >http://www.gaggle.net >Safe email for students and teachers > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
