connect VB to mySql


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: connect VB to mySql

  1. #1
    Join Date
    Sep 2005
    Posts
    3

    connect VB to mySql

    Hi all,

    I need help! i'm new in VB and mysql. I plan to develop a software using VB and mySql, i goto mysql website but no idea which one to download, there're mysql 4.0 and API, should i download both?
    and if i complete the software, and package it into a cd and create an autorun cd, can it run on every pc? or i need to configure mySql in every pc?

    THanks for help!

  2. #2
    Join Date
    Jul 2005
    Posts
    9
    I can answer your mySQL question, but not the VB question (not really my area).

    Inside of your VB program, it should handle all of the connecting to the mySQL server. The mySQL server should be on a remote PC (for optimal performance) and all clients will connect to it. The API (from what I've seen on the site) is not available for VB (But is for .NET).

    Just keep the client /server idea in mind. Installing mySQL on each PC isn't what you want to do.

  3. #3
    Join Date
    Sep 2005
    Posts
    3
    I recommend this: http://www.microsoft.com/sql/msde/default.mspx if you are going to have it on one server. Or if it is going to be on individual PCs and install during deployment, then I recommend MS Access.

  4. #4
    Join Date
    Aug 2005
    Posts
    6
    just download mysql 4.0

    inorder to connect vb to mysql u hve use odbc connection......for that download myodbc...

    configure it...and connect to the mysql using the odbc connection in ur vb prog.....

Similar Threads

  1. vb mySQL connection problems in windows xp
    By nadaness in forum VB Classic
    Replies: 2
    Last Post: 08-11-2005, 10:35 PM
  2. Info abt hoe to connect VB and C/C++
    By Aruna in forum .NET
    Replies: 0
    Last Post: 07-18-2002, 11:07 AM
  3. Can VB 6 work with MySQL?
    By Daniel Blake in forum VB Classic
    Replies: 2
    Last Post: 06-14-2002, 06:05 AM
  4. Replies: 0
    Last Post: 03-12-2002, 11:58 PM
  5. OOP Concepts
    By Randy Charles Morin in forum Architecture and Design
    Replies: 42
    Last Post: 01-03-2002, 06:22 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center