SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Enthusiast
    Join Date
    Jun 2000
    Location
    Turnersvill, NJ
    Posts
    35
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hello,

    I am trying to connect (through VB6) to my mySQL DB (I rent server space from Jumpline.com)...

    I have been connecting to the DB with PHP by using localhost,'username','password'

    How does one connect with VB? I have searched the archives and came up empty...

    Thanks for your help

    (oh, also....if I use this command:
    mysqldump --opt -u username -p databasename > dump.sql

    it would be dumping my database to dump.sql...but where would it be located?)

    Thanks,
    Keith
    singer/songwriter...that's why I ask all the questions!
    www.keithlubrant.com

  2. #2
    Serial Publisher silver trophy aspen's Avatar
    Join Date
    Aug 1999
    Location
    East Lansing, MI USA
    Posts
    12,937
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    VB is a client side language not a server side language.

    You can't connect to a DB with it.

    You can do it however with ASP, which uses VB. But if you want to connect to MySQL you're going to either need to get ASP for *nix or MySQL for windows, neither of which are common configurations unless you're running your own server.


    Edit:


    heh... I assumed he was talking about VB script

    <Edited by aspen on 01-09-2001 at 09:02 AM>
    Chris Beasley - I publish content and ecommerce sites.
    Featured Article: Free Comprehensive SEO Guide
    My Guide to Building a Successful Website
    My Blog|My Webmaster Forums

  3. #3
    SitePoint Wizard silver trophy Karl's Avatar
    Join Date
    Jul 1999
    Location
    Derbyshire, UK
    Posts
    4,411
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can connect Visual Basic to MySQL as I hvae done so in the past.

    You need a set of files from the MySQL downloads page called MyODBC once you have installed them on your PC you need to use RDO to select the correct ODBC connection and input your parameters for connection such as server address etc.

    There is one big BUT though, you will not be able to connect to your Jumpline MySQL database as it will only accept connections from the localhost and I doubt they will change it for you.
    Karl Austin :: Profile :: KDA Web Services Ltd.
    Business Web Hosting :: Managed Dedicated Hosting
    Call 0800 542 9764 today and ask how we can help your business grow.

  4. #4
    SitePoint Enthusiast
    Join Date
    Jun 2000
    Location
    Turnersvill, NJ
    Posts
    35
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    darn....I was thinking I would not be allowed access...Thanks for you input, guys! It was worth a shot...

    -Keith
    singer/songwriter...that's why I ask all the questions!
    www.keithlubrant.com


Bookmarks

Posting Permissions

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