SQL ExcelSQL Excel

Freeware Excel Add-In - Simplify data retrieval from SQL Server, Oracle, Sybase, MySQL, DB2, Firebird and any other ODBC compliant database

SQL Excel Support
Welcome, Guest
Please Login or Register.    Lost Password?
SQL Excel Support Database Specific MYSQL
Re:Non local intranet server MYSQL (1 viewing) (1) Guest
MYSQL discussion area. Please list MYSQL specific issues here.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Non local intranet server MYSQL
#280
kellerh (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Non local intranet server MYSQL 4 Months ago Karma: 0  
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.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#281
admin (Admin)
Admin
Posts: 175
graph
User Online Now Click here to see the profile of this user
Re:Non local intranet server MYSQL 4 Months ago Karma: 1  
Hi

Please can you take a look at this page http://www.sqlexcel.net/SQL-Excel-Support/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
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Thanks for using the forum SQL Excel Freeware Add-inget the latest posts directly to your desktop
 

Google Translate

Main Menu

Copyright SQL Excel, 2007-2008 | valid xhtml? | valid CSS? |Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation