Announcement Announcement Module
Collapse

myhosting.com Forum Guidelines

Welcome to the myhosting.com Forums! The purpose of this forum is to allow you to discuss topics relating to hosting and topics of interest with other myhosting.com Customers. The primary focus should relate to issues not generally included in our Wiki or Control Panel, or information not provided by our Customer Support Team. Some examples include programming and coding support, web site design ideas and SEO practices.

The forum is not meant as a replacement to our Wiki or Customer Support. We highly recommend searching our Wiki before posting on the forum. Also, if you have a question for our Customer Support team, please contact them as you would normally.

We ask that if you have any complaints or questions relating specifically to your account, that you address them to our Customer Support department. Do not post personal account information such as passwords or other sensitive and private information the forum, as this type of information is best kept secret. Also, please be respectful of other users and refrain from defamatory comments or use of coarse language.

We will visit the forum from time to time, and contribute to various topics. We reserve the right to delete any posts which are deemed offensive or against the spirit of the forum. Any spamming or illegal activity will not be tolerated. We also reserve the right to block any user who violates these guidelines.

To get started, we welcome you to sign up at our User Management site. Any account created there will have access to these forums, our Wiki, our Ideas site and commenting permission on our Status Blog.
See more
See less
MySQL Problem Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL Problem

    i'm developer ybtas.com. i'm programming with ASP in this site. but i have a problem.

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


    i use MySQL ODBC 3.51 Driver in my localhost or my other servers. it's working. but in this site it's not working. what can i do for that?

  • #2
    Re: MySQL Problem

    Hi There,

    The simple answer is that the MySQL server only listens for local connections from the Linux hosting server, so you cannot make a connection from the Windows 2003 server to your Linux-based MySQL database.

    We do provide a free MS SQL database which you can use with your Windows hosting account. You can activate it by logging in at https://support.myhosting.com.

    Comment


    • #3
      And So?

      I would very much like to write data into my MySQL db at myhosting.com from a ColdFusion site at another location. I was thinking about setting up a php script at MyHosting to do it indirectly, but is there another way?

      Comment


      • #4
        Originally posted by thomp View Post
        I would very much like to write data into my MySQL db at myhosting.com from a ColdFusion site at another location. I was thinking about setting up a php script at MyHosting to do it indirectly, but is there another way?
        Hey Thomp. The MySQL server in your Linux shared hosting account listens for local connections only. Thus, it's not possible to communicate with your MySQL database from your ColdFusion site at another location.

        You could write or find an API to run in your myhosting.com website that accepts requests from your ColdFusion site, and translate them into database queries that it runs in your MySQL database.

        However, I wouldn't recommend doing that. You'd need to put a lot of safeguards in place to ensure that nobody else can use the API. Also, you'd need to have the API accessible via HTTPS only, else risk the chance of someone eavesdropping on the authentication credentials.

        My next question for you is this:

        What are you trying to accomplish?

        Cheers,
        Nick

        Comment


        • #5
          Thank you very much for the quick response

          The ColdFusion site is a membership site that I maintain. It has a shopping cart and we'll be selling a product there. When someone makes a purchase a script runs that sends both us and the user an email with some special purchase info. I also want to write this same data into a DB. The MySQL at MyHosting seemed very convenient for this purpose. The transaction would be one way. Data from the ColdFusion site gets sent to a php script (or other interface) at MyHosting that writes it into a table and returns an error code. The script wouldn't do anything else so it wouldn't be of much use to anyone with malicious intent, unless they could access the source, which is an issue we already have with php scripts at MyHosting that interact with the MySQL server on our Linux hosting account.

          Comment


          • #6
            Hi Thomp. If that's all that you need to accomplish, then I'd just write a quick PHP script in your myhosting.com account that accepts a couple of arguments, and writes that data to a database table.

            For example, requesting:
            Code:
            http://your-domain.com/save_order_details.php?id=123&total=9.95&billing_name=Nick%20Hoffman&billing_address=10%20Bay%20Street
            would result in save_order_details.php parsing, sanitizing, and storing the order details in the appropriate database table.

            Does that help?

            Comment


            • #7
              Thanks a bunch!! That's exactly what I thought I should probably do. But wasn't sure because I didn't know the availability of existing solutions or that the MySQL server was only listening locally (although thats what appeared to be the issue from testing). You're post was the only thing I could find that states this directly.

              The FAQ on MySQL didn't mention this explicitly. I think this is important info that should be posted.

              Cheers,

              Comment


              • #8
                Originally posted by thomp View Post
                The FAQ on MySQL didn't mention this explicitly. I think this is important info that should be posted.
                Thanks for letting us know! I've updated the MySQL wiki article to include:

                All MySQL database server daemons listen on localhost. Thus, when configuring a website to use a MySQL database, please ensure that the Host parameter is set to localhost. Please note that this means that it is not possible to connect to your MySQL database from a remote host.

                Comment

                Working...
                X