Ynt: Connecting to MySQL w/VB
see this : About mysql & vb6 http://www.avukatpro.com/mysql.html - Original Message - From: Dennis Salguero <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, June 29, 2001 6:03 AM Subject: Re: Connecting to MySQL w/VB > - Original Message - > From: "Robert Skinner" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, June 28, 2001 7:44 PM > Subject: Connecting to MySQL w/VB > > > > I am trying to connect to MySQL using a connection string using VB6. The > > read part is great but I don't seem to be able to add records. Can anyone > > steer me in the right direction? > > A bit more information might help us help you. If you the db reads work > fine, then you at least have the connection made - that's already half-way > there! I have done extensive work with MySQL and VB/VBScript, but if you can > execute a SELECT query (as your e-mail indicates) I don't see how you would > have problems executing an INSERT query (assuming the SQL statement is > valid). > > What exactly seems to be the problem? > > Good Luck, > > Dennis > ** > Beridney Computer Services > http://www.beridney.com > > > > - > 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: Connecting to MySQL w/VB
I am using a DLL called MYVBQL.dll which is also on the mysql web site and it works like a dream. Don't need no ODBC driver, and all that stuff. Similar to ADO but also quite different. Some bugs but if you stick to SQL statements to insert/update/delete info it works like a dream and is very fast. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > ]On Behalf > Of [EMAIL PROTECTED] > Sent: 29 June 2001 10:41 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: Connecting to MySQL w/VB > > > Give MyODBC a try, its on the mysql.com site > and its given my no problems at all in vb. > > Sean > > -Original Message- > From: Robert Skinner [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 29, 2001 3:45 AM > To: [EMAIL PROTECTED] > Subject: Connecting to MySQL w/VB > > > I am trying to connect to MySQL using a connection string > using VB6. The > read part is great but I don't seem to be able to add > records. Can anyone > steer me in the right direction? > > [EMAIL PROTECTED] > > > - > 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 > > > - 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: Connecting to MySQL w/VB
Give MyODBC a try, its on the mysql.com site and its given my no problems at all in vb. Sean -Original Message- From: Robert Skinner [mailto:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 3:45 AM To: [EMAIL PROTECTED] Subject: Connecting to MySQL w/VB I am trying to connect to MySQL using a connection string using VB6. The read part is great but I don't seem to be able to add records. Can anyone steer me in the right direction? [EMAIL PROTECTED] - 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: Connecting to MySQL w/VB
just curious, how do you connect to mysql through ASP? i have tried connecting with "MyODBC", i installed myodbc and then i create the connection string in asp like this set conn=server.createobject("adodb.connection") conn.open "driver={mysql};server=192.168.0.1;user=user;pass=pass;database=db1" i was just curious to see how you connect to mysql with asp jason asp developer working in mysql :) - Original Message - From: "Dennis Salguero" <[EMAIL PROTECTED]> To: "Jason Brunk" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 28, 2001 11:38 PM Subject: Re: Connecting to MySQL w/VB > - Original Message - > From: "Jason Brunk" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, June 28, 2001 8:18 PM > Subject: Re: Connecting to MySQL w/VB > > > > i know i am definitly knew at this, but his permissions could be set more > or > > less for read only. > > Yes, it's possible that the permissions are not set properly. However, I was > assuming that, since he had just started working with MySQL, he was using > the root account, unmodified, which would give him complete access. It's > been my experience that it is much easier to work with ASP & MySQL than VB & > MySQL because of the databound objects, and wouldn't be surprised if the > problem that the original poster has does not apply to ASP. > > Good Luck, > > Dennis > ** > Beridney Computer Services > http://www.beridney.com > > - 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: Connecting to MySQL w/VB
- Original Message - From: "Jason Brunk" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 28, 2001 8:18 PM Subject: Re: Connecting to MySQL w/VB > i know i am definitly knew at this, but his permissions could be set more or > less for read only. Yes, it's possible that the permissions are not set properly. However, I was assuming that, since he had just started working with MySQL, he was using the root account, unmodified, which would give him complete access. It's been my experience that it is much easier to work with ASP & MySQL than VB & MySQL because of the databound objects, and wouldn't be surprised if the problem that the original poster has does not apply to ASP. Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - 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: Connecting to MySQL w/VB
i know i am definitly knew at this, but his permissions could be set more or less for read only. i am just spitting junk out, i am new, but i don't like sitting idle in a group. i have been watching this thread closely, because i do developement on a large scale in ASP and VB. so just ignore me if i am being an idiot. Jason - Original Message - From: "Dennis Salguero" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 28, 2001 11:03 PM Subject: Re: Connecting to MySQL w/VB > - Original Message - > From: "Robert Skinner" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, June 28, 2001 7:44 PM > Subject: Connecting to MySQL w/VB > > > > I am trying to connect to MySQL using a connection string using VB6. The > > read part is great but I don't seem to be able to add records. Can anyone > > steer me in the right direction? > > A bit more information might help us help you. If you the db reads work > fine, then you at least have the connection made - that's already half-way > there! I have done extensive work with MySQL and VB/VBScript, but if you can > execute a SELECT query (as your e-mail indicates) I don't see how you would > have problems executing an INSERT query (assuming the SQL statement is > valid). > > What exactly seems to be the problem? > > Good Luck, > > Dennis > ** > Beridney Computer Services > http://www.beridney.com > > > > - > 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: Connecting to MySQL w/VB
- Original Message - From: "Robert Skinner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 28, 2001 7:44 PM Subject: Connecting to MySQL w/VB > I am trying to connect to MySQL using a connection string using VB6. The > read part is great but I don't seem to be able to add records. Can anyone > steer me in the right direction? A bit more information might help us help you. If you the db reads work fine, then you at least have the connection made - that's already half-way there! I have done extensive work with MySQL and VB/VBScript, but if you can execute a SELECT query (as your e-mail indicates) I don't see how you would have problems executing an INSERT query (assuming the SQL statement is valid). What exactly seems to be the problem? Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - 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
Connecting to MySQL w/VB
I am trying to connect to MySQL using a connection string using VB6. The read part is great but I don't seem to be able to add records. Can anyone steer me in the right direction? [EMAIL PROTECTED] - 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