Microsoft® Excel® based database addin

 

+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    kellerh is offline Junior Member
    Join Date
    Sep 2008
    Posts
    1

    Default Non local intranet server MYSQL

    how do i create a connection to a non local mysql database?

    i'm a newbie to vba and mysql so any help would be appreciated.

  2. #2
    admin's Avatar
    admin is offline Administrator
    Join Date
    Apr 2008
    Location
    Dublin, NYC
    Posts
    333
    Blog Entries
    1

    Default Re:Non local intranet server MYSQL

    Hi

    Please can you take a look at this page
    http://www.sqldrill.com/index.php?/FAQ/how-to-setup-up-a-connection-to-mysql-flash-demo.html

    I tried to make a short clip on this a while ago and hope this will help get you going.

    Basic thing is to install the MYSQL connector and then use this to setup the connection.
    On the remote server, you also need to make sure you are permissioned to connect to the database from your local machine (often this permission needs to be added explicitly)

    Please take a look at this video when you can. Hope it helps you get setup.
    Thanks, al
    SQL Drill Support
    www.sqldrill.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