SQLDrill.com - Excel Addin for using SQL

Microsoft® Excel® based database addin

 

Go Back   SQL Drill Excel Add-in > SQL Drill General Forum > Installation of SQL Drill

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-07-2010, 02:37 PM
Junior Member
 
Join Date: Feb 2010
Posts: 1
Default Connect to joomla DB

hi all, im sorry for posting this question but ive looked everywhere and i cant seem to get this answer...

I downloaded this extension and installed it, but now i have no idea how to get it to work.

The purpose is to get the tables in phpmyadmin from joomla to the excel, this is doable right?

I tried to configure this in excel but i have i have no idea what to do/chose after i click "add new connection", i mean what provider, or connection etc...

can anyone just point me to some tutorial and ill be on my way.



thx in advance
Reply With Quote
  #2 (permalink)  
Old 02-08-2010, 08:05 PM
admin's Avatar
Administrator
 
Join Date: Apr 2008
Posts: 325
Default

Hi

Hope all is fine.. The first time you set up a connection it can be a bit confusing.

There is a basic tutorial on setting up a connection to a mysql database here:
How to Setup up a connection to MYSQL (Flash Demo)


Maybe someone else knows where there is a better tutorial on setting up a mysql connection ? If anyone does know, it would be a big help if you could post it up.

After setting up the connection - if the database is hosted on a remote server (web hos..) -then you will need to setup the permissions on the remote server for your database ID to access the server from your computer.. This is nearly always required. You can just add a trusted IP to your database login ID (in the cpanel or in your server administration panel..).

I hope that is enough to get you going. Please let me know if you have any issues.

Thanks and have a good day
__________________
SQL Drill Support
www.sqldrill.com

Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
My new Vostro 220's Vista System Windows Mail Account fails to connect with my gmail account , how can they connect? Dorothea Dykes Queries 2 04-22-2009 06:04 PM
Cannot Connect a form..help please....!!! khaksar Access Forms 4 04-01-2009 01:15 PM
Interrogating MYSQL Db used by Joomla JSWNZ3 MYSQL with SQL Drill 1 02-22-2009 03:56 PM
Connect to internet anjanesh Programming (VBA, VB, C# etc) 2 01-27-2009 05:09 AM


All times are GMT. The time now is 09:09 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.0 |Website Pricer