Results 1 to 8 of 8

Thread: VB and MySQL

  1. Apr 3rd, 2005, 01:17 AM #1
    phrajib
    phrajib is offline

    Thread Starter
    Lively Member
    Join Date
    Mar 2005
    Location
    Dhaka, Bangladesh
    Posts
    102

    VB and MySQL

    I want to connect with MYSQL database from VB6. Help me, how I can do that.
    I have worked with Access and VB but not with server type database before.

    Rajib
    Reply With Quote Reply With Quote
  2. Apr 3rd, 2005, 07:22 AM #2
    Joacim Andersson
    Joacim Andersson is offline
    I'm about to be a PowerPoster! Joacim Andersson's Avatar
    Join Date
    Jan 1999
    Location
    Sweden
    Posts
    14,649

    Re: VB and MySQL

    If you've used ADO with Access then there isn't that big difference between the code you use to connect to MySQL. The main difference is the ConnectionString. Here's a generic ConnectionString that you can use with MySQL:
    "Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=ThePassword"
    Reply With Quote Reply With Quote
  3. Apr 4th, 2005, 12:34 AM #3
    kulitag
    kulitag is offline
    Hyperactive Member
    Join Date
    Mar 2005
    Location
    Manila, Philippines
    Posts
    486

    Re: VB and MySQL

    you can use dataenvironment as a connection
    Reply With Quote Reply With Quote
  4. Apr 5th, 2005, 02:27 AM #4
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: VB and MySQL

    Visit www.connectionstrings.com
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  6. Apr 5th, 2005, 02:32 AM #5
    VbMafia
    VbMafia is offline
    Addicted Member VbMafia's Avatar
    Join Date
    Sep 2004
    Location
    Pilipinas
    Posts
    177

    Re: VB and MySQL

    connect some dsn connection visit www.vbrad.com
    " I never did anything worth doing entirely by accident.... Almost none of my inventions were derived in that manner. They were achieved by having trained myself to be analytical and to endure and tolerate hard work."

    " Many of life's failures are experienced by people who did not realize how close they were to success when they gave up. "
    - Thomas Alva Edison-

    In God We Trust
    Reply With Quote Reply With Quote
  7. Apr 5th, 2005, 02:41 AM #6
    randem
    randem is offline
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385

    Re: VB and MySQL

    phrajib,

    Look here for an example. Look under Multi Database Control
    Reply With Quote Reply With Quote
  8. Apr 5th, 2005, 04:10 AM #7
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: VB and MySQL

    www.vbmysql.com
    Reply With Quote Reply With Quote
  9. Apr 8th, 2005, 02:48 PM #8
    Gensor
    Gensor is offline
    Fanatic Member
    Join Date
    May 2004
    Location
    Granby, Qc, Canada
    Posts
    602

    Re: VB and MySQL

    I'm trying to setting up a connection with a Data Environment to a MySQL DB using MyOLEDB Provider 3.0.

    In the Data Link Properties Dialog, I filled all the blank like this :

    Data Source : Data
    Location : localhost
    User name : root
    Password : ***

    The user and password are correct.

    When I click on Test Connection, it always took me to the "MySQL Data Source Name Setup" dialog and there, I don't know what to do.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width