connecting mysql with vb6


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 6 of 6

Thread: connecting mysql with vb6

  1. #1
    Join Date
    Dec 2005
    Posts
    28

    Question connecting mysql with vb6

    sir
    i am using vb6 with access, but now i want to migrate to mysql on remote server.Can i connect to mysql without using odbc , or if i use ODBC and make a package and install it in other system will dsn be created there.
    plz help
    thanks in advance

    Bye
    sreejit

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    You can connect to MySQL via ODBC without creating a DSN. Your ADO connection string should look like this:

    driver={mysql}; database=yourdatabase;server=yourserver;uid=username;pwd=password;option=16386;
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  3. #3
    Join Date
    Dec 2005
    Posts
    28
    thank u sir
    mysql server is provided by yahoo
    its not connecting its giving error cannot found mysql server on server name
    plz help

  4. #4
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    Have you asked Yahoo? What did they say?
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  5. #5
    Join Date
    Dec 2005
    Posts
    28
    yes i had asked yahoo, they said there server does not support third party access.Now what should i do. plz suggests, if there is any other way to access the mysql db. or any other server which provide free or ecnomic mysql server with ip support access.

    if anyone know abt it plz let me know

    thanks in advance.
    sreejit

  6. #6
    Join Date
    Dec 2003
    Location
    San Diego
    Posts
    202
    Is the site you are speaking of a Yahoo! Merchant Solutions site for a Yahoo! store? I ask because the database used for their catalog and inventory managers can only be accessed by the web-based UI they provide.

    To add more features and dynamism to your site, they do include a MySQL database that you can use and access via PHP or PERL. This is a separate database for your own use within the site.

    See the section called "MySQL, PHP, and Perl" at the following URI,
    http://help.yahoo.com/help/us/store/site/

    As an alternative, they do offer the data from the catalog manager in XML format for your own custom reporting. You could call this file and parse it for your own needs.

    Export Yahoo! DB to XML

    Good luck,
    Michael Sanchez
    Managing Technical Editor
    Forum Moderator
    FreeVBCode.com

Similar Threads

  1. Connecting to MS-Access 2003 with VB6
    By Miles Tones in forum VB Classic
    Replies: 12
    Last Post: 09-28-2009, 02:53 PM
  2. Connecting to a MySQL server on LAN
    By vradhkar in forum VB Classic
    Replies: 2
    Last Post: 08-07-2005, 03:30 PM
  3. Connecting Java to MySQL
    By snowstorm in forum Java
    Replies: 3
    Last Post: 05-04-2005, 02:01 PM
  4. VB6 ADO - rogue client not connecting to Access
    By charlie in forum VB Classic
    Replies: 3
    Last Post: 02-23-2002, 02:41 AM
  5. Problems connecting Access 2000 to VB6
    By Jason in forum VB Classic
    Replies: 2
    Last Post: 03-01-2001, 10:03 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