Microsoft® Excel® based database addin

 
+ Reply to Thread
Results 1 to 4 of 4
  1. 12-18-2008 10:15 PM #1
    fernsy
    fernsy is offline Junior Member
    Join Date
    Dec 2008
    Posts
    2

    Default Please help with remote database connection

    Hi There,

    Can anyone please explain very well how to connect to a remote database. This database was created in cPanel, the database is used for a custom CRM application.

    I have seen the video where it shows you how to connect a new MySQL ODBC but it hasn't helped me...I feel a bit confused.

    I have downloaded and installed all necessary apps, SQLExcel, mysql-connector-odbc-3.51.27-win32 and even installed mysql-essential-5.1.30-win32 so I know I have the correct tools.

    What I need to do is connect to a live database which lives at on a remote server under a domain name. when I get to this area:
    [img size=497]http://www.italkit.com.au/mysql.gif[/img]

    I get confused because there is no database to drop down from...The video http://www.sqlexcel.net/SQL-Excel-Su...lash-Demo.html shows a Northwind database in a drop down for selection though how is that a remote database connection since its a sample database on windows. I have this web page for reference: http://www.connectionstrings.com/mysql but still confused as the image above requires to choose a database from the dropdown or else I get an error.

    PLEASE HELP...going insane here!

    Thanks in advance, much appreciated!!!

    kind regards,

    Fernando
    Reply With Quote Reply With Quote  
  2. 12-19-2008 02:50 PM #2
    admin's Avatar
    admin
    admin is offline Administrator
    Join Date
    Apr 2008
    Location
    Dublin, NYC
    Posts
    333
    Blog Entries
    1

    Default Re:Please help with remote database connection

    hi Sorry, for the delay in replying.

    If you enter in the correct Server, login Id and password then you should normally see the availabled database in the dropdown of the MYSQL Connector Form (this is assuming you are permissioned to connect to the database server from your computer)

    So there are two things
    - Check in the CPANEL for what the database login, password and server (database host name - usually something like say mysql.somesite.com) and put these into the form you showed in your post. Also, put in some labels in the first 2 text boxes of the form - these are just for your reference.
    See if you can pick the database from the dropdown.

    - If you can get to the database from your client (computer) then you will need to go to your CPANEL to enable connectivity from your client. You can typically do this by adding an IP address or hostname from which you can connect to the remote database server. You can check for this part with your host company...

    If you set all the above up you should be able to hit the "tesT" button and get a "success" message from the MYSQL connector form.

    Then you are ready to go into the Excel addin and add the connection (looking for the data source name that you specified when you set up the connection)

    I hope this will get you going. Let me know if you have any problems with this.

    thanks
    Al
    SQL Drill Support
    www.sqldrill.com
    Reply With Quote Reply With Quote  
  3. 12-19-2008 09:21 PM #3
    fernsy
    fernsy is offline Junior Member
    Join Date
    Dec 2008
    Posts
    2

    Default Re:Please help with remote database connection

    Hi and thank you for your response!

    I have tried everything you said...In cPanel there is a link called 'Remote MySQL' where you can add the IP address from where I am to connect to but I still get access denied...what a bummer.

    Are you able to help me see this database in the dropdown if I download it from phpMyAdmin? I have the database in .sql format but I have no idea how to get it to show up in the dropdown.

    Thanks for your help ! (again)

    kind regards,
    Fernando
    Reply With Quote Reply With Quote  
  4. 12-20-2008 09:15 PM #4
    admin's Avatar
    admin
    admin is offline Administrator
    Join Date
    Apr 2008
    Location
    Dublin, NYC
    Posts
    333
    Blog Entries
    1

    Default Re:Please help with remote database connection

    Hi Fernando

    Sorry you are having problems getting the connection going.

    One small thing, did you try to just type the database name into the dropdown box - is that possible ?


    When you get the "access denied" message it normally will give you the IP or host it is denying.. It happens to me sometime and I get a message something like "access denied to 73.145.257.252"

    Basically, the message should give you the details of what you need to add the remote access section in the cpanel.

    The IP or hostname you need to add in to the cpanel will be coming from your internet ISP (so not the IP of your computer)


    I think it might be the fastest if you contact the hosting company and ask them if them for some help to make sure the mysql server is remotely accessible.

    Here is an article that explains in more details about remotely accessing mysql.
    http://www.cyberciti.biz/tips/how-do...se-server.html

    Hoever, normally you would not need all this - especially as you have already found the setting in the cpanel that should enable remote access)

    Please try to contact the host about it. Also, which hosting company is this ? That might help me find out a bit more.

    Sorry this is a pain to setup for you but usually it is not so hard.. Please let me know how it goes and have a nice weekend

    Al
    SQL Drill Support
    www.sqldrill.com
    Reply With Quote Reply With Quote  
« Previous Thread | Next Thread »

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

Forum Rules