RE: new user basic questions
Welcome to the Club! Connecting to a mySQL database would be the same way in VB6 as MS SQL or Access, via ODBC. You should download myODBC from mysql.com. On Microsoft Oses it is easier to develop apps via ODBC because its like saving you 5-10 lines of code to write. If it's a web application and you need to upload it to *Nix box, then you should NOT use ODBC. As Brandon previously stated. Microsoft sometimes say they have "standards in place" which really means they made up their own *cough*java*cough* The only database that is even NEAR the SQL92 standards is Microsoft's MS SQL Server 6.5 - 2000, and this isn't even SQL92 standard! Either is Oracle ( I think) I doubt that Microsoft will come out with documentation on VB front ends with mySQL backends. But I am sure there are people that do do it! I just find it easier with an HTML front end than VB or any other programming language! Good Luck! Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Rodney Broom [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 2:28 PM To: [EMAIL PROTECTED] Subject: Re: new user basic questions From: <[EMAIL PROTECTED]> > I am new to dababases in general... Learn SQL (which it sounds like you've done). It's almost always going to be the standard tool between various database vendors and APIs. > ...would like to use Visual Basic ...to edit the database. I won't make any MickySoft vs. *NIX cracks. I'm not a VB person, but I'm thrilled to see students working with real world tools. (In school, all I got was an abacus.) I searched briefly on the mysql.com site and found a few listings. http://www.mysql.com/doc/manual.php?search_query=VB&depth=0 In short, it still looks like ODBC is the way to go. I've had folks connect their MS Access and Crystal Reports via ODBC to my MySQL databases and only had limited problems. For instance, the int() in MySQL was too big for Crystal Reports. > -at least one way to connect to the Mysql database with VB6 To use ODBC, you set up a user/pass/host in MySQL to allow clients to connect. Then you set up a DSN on your MS Windows machine that points at the MySQL host, using the proper user/pass. You'll need the ODBC drivers, I can only suggest checking your VB docs, and/or the "ODBC Data Sources" option in the Control Panel to figure this out. As for writing the actual connect statement, I don't have the foggiest idea. Check the docs that came with your compiler. > -what commands I can use in VB6... I can't help you there. Definately the docs that came with your compiler. > ...a site that will point out how to use the commands ~Maybe~ microsoft.com. My experience is that their site is usually not very helpful. > -can I use an SQL book for reference on commands Yes, or the MySQL docs (section 6 on the mysql.com site). Unless you run into one of the many situations where MicroSoft is claiming that they are using a standard when they really aren't, then most of your SQL92 knowledge should just work through any API on any SQL database. At the very least, if VB6 offers a direct SQL interface to MySQL, then you should be able to do anything with SQL that MySQL says it supports. > ...only a senior in high school "Only"? In just a few years, you and your pals will be running the world. > ...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. Heh, join the club. Don't worry about your resources not being human beings. Finding and maintaining a good set of documentation that works for you is a big part of what makes you salable in the real world. Life on the job is an open book test; you don't have to know everything, you just have to know how to find it fast enough to make your boss happy. > Any help with any of those questions is much appreciated. I'm very encouraged to see a newcomer here. I hope that you get plenty of assistance from this group. Hint, hint. --- Rodney Broom Programmer: Desert.Net - 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 - 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
Re: new user basic questions
>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
Re: new user basic questions
From: <[EMAIL PROTECTED]> > I am new to dababases in general... Learn SQL (which it sounds like you've done). It's almost always going to be the standard tool between various database vendors and APIs. > ...would like to use Visual Basic ...to edit the database. I won't make any MickySoft vs. *NIX cracks. I'm not a VB person, but I'm thrilled to see students working with real world tools. (In school, all I got was an abacus.) I searched briefly on the mysql.com site and found a few listings. http://www.mysql.com/doc/manual.php?search_query=VB&depth=0 In short, it still looks like ODBC is the way to go. I've had folks connect their MS Access and Crystal Reports via ODBC to my MySQL databases and only had limited problems. For instance, the int() in MySQL was too big for Crystal Reports. > -at least one way to connect to the Mysql database with VB6 To use ODBC, you set up a user/pass/host in MySQL to allow clients to connect. Then you set up a DSN on your MS Windows machine that points at the MySQL host, using the proper user/pass. You'll need the ODBC drivers, I can only suggest checking your VB docs, and/or the "ODBC Data Sources" option in the Control Panel to figure this out. As for writing the actual connect statement, I don't have the foggiest idea. Check the docs that came with your compiler. > -what commands I can use in VB6... I can't help you there. Definately the docs that came with your compiler. > ...a site that will point out how to use the commands ~Maybe~ microsoft.com. My experience is that their site is usually not very helpful. > -can I use an SQL book for reference on commands Yes, or the MySQL docs (section 6 on the mysql.com site). Unless you run into one of the many situations where MicroSoft is claiming that they are using a standard when they really aren't, then most of your SQL92 knowledge should just work through any API on any SQL database. At the very least, if VB6 offers a direct SQL interface to MySQL, then you should be able to do anything with SQL that MySQL says it supports. > ...only a senior in high school "Only"? In just a few years, you and your pals will be running the world. > ...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. Heh, join the club. Don't worry about your resources not being human beings. Finding and maintaining a good set of documentation that works for you is a big part of what makes you salable in the real world. Life on the job is an open book test; you don't have to know everything, you just have to know how to find it fast enough to make your boss happy. > Any help with any of those questions is much appreciated. I'm very encouraged to see a newcomer here. I hope that you get plenty of assistance from this group. Hint, hint. --- Rodney Broom Programmer: Desert.Net - 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
