Results 1 to 11 of 11

Thread: Help connecting to a remote MySQL server...

  1. #1
    Ғо ѕніzzLє му піzzLє chicken's Avatar
    Join Date
    Nov 2005
    Location
    Kent
    Posts
    1,576
    Thanks
    28
    Thanked
    52 times in 43 posts

    Help connecting to a remote MySQL server...

    This situation is a bit difficult to explain, but basically I am trying to connect to a separately hosted MySQL server from a Windows server but I'm running into difficulty getting the connection string right.

    • Server 1: Where the main page resides, this server normally uses MSSQL
      I have FTP access and Remote Desktop access to this server but no installation rights for the ODBC driver.
      -
    • Server 2: Secondary site with a MySQL database containing some info I need to reference
      I have FTP and normal web-based control over this one with full admin rights right up to the reseller account above the site-admin.


    I make pages for Server 1 on a regular basis, but now I need to access some info from Server 2's SQL database for a page on Server 1.

    Server 2 is set up to allow remote SQL access to Server 1's IP (I have tested this using my IP and MySQL Query Browser to connect and it works).

    My problem seems to be the connection string. I can't seem to get it right because either Server 1 doesn't have the MySQL ODBC driver installed or Server 2 isn't responding to the only requests Server 1 seems to work with because they're for a MSSQL connection.

    This seemed to be the most promising:
    Code:
    Provider=MS Remote;
    Remote Provider=sqloledb;
    Data Source=webxx.extendcp.co.uk;
    Server=webxx.extendcp.co.uk;
    Port=3306;
    Database=webxx-ppd;
    Uid=xxxxxx;
    Pwd=xxxxxxx;
    But brought back:
    Code:
    RDSServer.DataFactory error '80070005'
    
    RDS Server Error: The server has denied access to the default RDS Handler used to access this page. See the Server Administrator for more information about server security settings.


    Give me actual SQL to do and I'm fine but I'm not too hot on the details of the connections so any suggestions would be very helpful!
    1.21 GIGAWATTS!!!!!

  2. #2
    Gentoo Ricer
    Join Date
    Jan 2005
    Location
    Galway
    Posts
    11,039
    Thanks
    1,014
    Thanked
    944 times in 704 posts
    • aidanjt's system
      • Motherboard:
      • Asus Strix Z370-G
      • CPU:
      • Intel i7-8700K
      • Memory:
      • 2x8GB Corsiar LPX 3000C15
      • Storage:
      • 500GB Samsung 960 EVO
      • Graphics card(s):
      • EVGA GTX 970 SC ACX 2.0
      • PSU:
      • EVGA G3 750W
      • Case:
      • Fractal Design Define C Mini
      • Operating System:
      • Windows 10 Pro
      • Monitor(s):
      • Asus MG279Q
      • Internet:
      • 240mbps Virgin Cable

    Re: Help connecting to a remote MySQL server...

    You need the MySQL ODBC driver installed on server 1, you also might check if server 1 is accepting connections from server 2 with a mysql client or GUI tools on that machine.
    Quote Originally Posted by Agent View Post
    ...every time Creative bring out a new card range their advertising makes it sound like they have discovered a way to insert a thousand Chuck Norris super dwarfs in your ears...

  3. #3
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,147
    Thanks
    798
    Thanked
    2,151 times in 1,407 posts

    Re: Help connecting to a remote MySQL server...

    Whats the app/platform your trying too connect from?

    also remeber that mysql is an utter waste of space of a server, and like clamidia is spreading vastly un-controlled and too far with the 'less aware' generations. It also suddenly becomes insainly expensive when you get into really big DB teritory. Its dog slow, and barely has any features. I can't stand it. There are so many better FREE and free to use packages on the market. Why the hell use it?

    It just fails on all grounds.
    throw new ArgumentException (String, String, Exception)

  4. #4
    Senior Member ajbrun's Avatar
    Join Date
    Apr 2004
    Location
    York, England
    Posts
    4,840
    Thanks
    4
    Thanked
    25 times in 13 posts

    Re: Help connecting to a remote MySQL server...

    It's late and I'm tired, so forgive me if I misunderstand .

    Try this test your connection info and get a correct connection string at the end of it:

    * Create a new file somewhere with a .udl extension, then open it.
    * Select the appropriate DB connection in the providers tab.
    * Enter your server information, username and password in the connection tab.
    * Select the database from the list.
    * Click test connection. Assuming your information is correct, it should connect fine.
    * Click OK.
    * Open your .udl file in wordpad/notepad/similar. This should show you your connection string.

  5. #5
    Gentoo Ricer
    Join Date
    Jan 2005
    Location
    Galway
    Posts
    11,039
    Thanks
    1,014
    Thanked
    944 times in 704 posts
    • aidanjt's system
      • Motherboard:
      • Asus Strix Z370-G
      • CPU:
      • Intel i7-8700K
      • Memory:
      • 2x8GB Corsiar LPX 3000C15
      • Storage:
      • 500GB Samsung 960 EVO
      • Graphics card(s):
      • EVGA GTX 970 SC ACX 2.0
      • PSU:
      • EVGA G3 750W
      • Case:
      • Fractal Design Define C Mini
      • Operating System:
      • Windows 10 Pro
      • Monitor(s):
      • Asus MG279Q
      • Internet:
      • 240mbps Virgin Cable

    Re: Help connecting to a remote MySQL server...

    Quote Originally Posted by TheAnimus View Post
    Whats the app/platform your trying too connect from?

    also remeber that mysql is an utter waste of space of a server, and like clamidia is spreading vastly un-controlled and too far with the 'less aware' generations. It also suddenly becomes insainly expensive when you get into really big DB teritory. Its dog slow, and barely has any features. I can't stand it. There are so many better FREE and free to use packages on the market. Why the hell use it?

    It just fails on all grounds.
    That is utter clap.. O'Reilly media, Ticketmaster, Redhat, Forrester Research, Google, etc, all have really tiny databases I'm sure. And few sites are faster than Google, too.
    Quote Originally Posted by Agent View Post
    ...every time Creative bring out a new card range their advertising makes it sound like they have discovered a way to insert a thousand Chuck Norris super dwarfs in your ears...

  6. #6
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,147
    Thanks
    798
    Thanked
    2,151 times in 1,407 posts

    Re: Help connecting to a remote MySQL server...

    yes because google use mysql. Only they don't.

    They use a highly modified version, for only some tasks. So that means it must be the dogs bollocks dosen't it?

    Ticketmaster site is hardly a good example of a well run smooth fast website is it?

    If the best adovacy you can come up with is someones using it? how do you know which is the best, all vendor DBs are used, even column store and datawarehouse packages, that dosen't mean there good.
    throw new ArgumentException (String, String, Exception)

  7. #7
    Gentoo Ricer
    Join Date
    Jan 2005
    Location
    Galway
    Posts
    11,039
    Thanks
    1,014
    Thanked
    944 times in 704 posts
    • aidanjt's system
      • Motherboard:
      • Asus Strix Z370-G
      • CPU:
      • Intel i7-8700K
      • Memory:
      • 2x8GB Corsiar LPX 3000C15
      • Storage:
      • 500GB Samsung 960 EVO
      • Graphics card(s):
      • EVGA GTX 970 SC ACX 2.0
      • PSU:
      • EVGA G3 750W
      • Case:
      • Fractal Design Define C Mini
      • Operating System:
      • Windows 10 Pro
      • Monitor(s):
      • Asus MG279Q
      • Internet:
      • 240mbps Virgin Cable

    Re: Help connecting to a remote MySQL server...

    Quote Originally Posted by TheAnimus View Post
    yes because google use mysql. Only they don't.

    They use a highly modified version, for only some tasks. So that means it must be the dogs bollocks dosen't it?
    No, they write tools to work with the engine, they don't have a 'highly modified version', nor do they need to. And they use it a lot.

    Quote Originally Posted by TheAnimus View Post
    Ticketmaster site is hardly a good example of a well run smooth fast website is it?
    Works fine for me, graphics are a tad slow to load, everything else is fine, not that it has anything to do with the database, unless they load all their graphics from database, which they don't. Their site hosts a lot of data, it's another example of why your sweaping statement is false.

    Quote Originally Posted by TheAnimus View Post
    If the best adovacy you can come up with is someones using it? how do you know which is the best, all vendor DBs are used, even column store and datawarehouse packages, that dosen't mean there good.
    Nice strawman there, very good. I didn't give arbitrary names of companies that use it, I gave names of big companies with very big data storage needs for their sites.
    Quote Originally Posted by Agent View Post
    ...every time Creative bring out a new card range their advertising makes it sound like they have discovered a way to insert a thousand Chuck Norris super dwarfs in your ears...

  8. #8
    mush-mushroom b0redom's Avatar
    Join Date
    Oct 2005
    Location
    Middlesex
    Posts
    3,306
    Thanks
    143
    Thanked
    346 times in 264 posts
    • b0redom's system
      • Motherboard:
      • Some iMac thingy
      • CPU:
      • 3.4Ghz Quad Core i7
      • Memory:
      • 24GB
      • Storage:
      • 3TB Fusion Drive
      • Graphics card(s):
      • nViidia GTX 680MX
      • PSU:
      • Some iMac thingy
      • Case:
      • Late 2012 pointlessly thin iMac enclosure
      • Operating System:
      • OSX 10.8 / Win 7 Pro
      • Monitor(s):
      • Dell 2713H
      • Internet:
      • Be+

    Re: Help connecting to a remote MySQL server...

    Quote Originally Posted by aidanjt View Post
    That is utter clap.. O'Reilly media, Ticketmaster, Redhat, Forrester Research, Google, etc, all have really tiny databases I'm sure. And few sites are faster than Google, too.
    and Yahoo...

  9. #9
    mush-mushroom b0redom's Avatar
    Join Date
    Oct 2005
    Location
    Middlesex
    Posts
    3,306
    Thanks
    143
    Thanked
    346 times in 264 posts
    • b0redom's system
      • Motherboard:
      • Some iMac thingy
      • CPU:
      • 3.4Ghz Quad Core i7
      • Memory:
      • 24GB
      • Storage:
      • 3TB Fusion Drive
      • Graphics card(s):
      • nViidia GTX 680MX
      • PSU:
      • Some iMac thingy
      • Case:
      • Late 2012 pointlessly thin iMac enclosure
      • Operating System:
      • OSX 10.8 / Win 7 Pro
      • Monitor(s):
      • Dell 2713H
      • Internet:
      • Be+

    Re: Help connecting to a remote MySQL server...

    Anyway, returning to the matter at hand....

    How are you trying to connect? PHP?

  10. #10
    Ғо ѕніzzLє му піzzLє chicken's Avatar
    Join Date
    Nov 2005
    Location
    Kent
    Posts
    1,576
    Thanks
    28
    Thanked
    52 times in 43 posts

    Re: Help connecting to a remote MySQL server...

    Wow, sorry to have started a DB Server fight! Heheh! Thanks for all the replies anyway guys!

    In reply to some of the questions:

    I'm using ASP and don't have a choice of PHP.

    I'd love to install the ODBC driver but I can't install anything from that login. I have tried to do it manually but although the driver registering exe reported a success it doesn't work, I think this is to do with the files being outside the default folder, or possibly it just needs a reboot (which I can't do). I'd ask the host for help but they barely help us at the best of times and currently there are some high-up politics going on regarding that that I really don't want to get involved in.

    I know the MySQL server accepts remote connections from predefined IP addresses as I have tested it from my own PC.

    I just thought it would be fairly straight forward to do this, I guess not.
    Maybe I should just leave it for now and get looking into better hosting... Has anyone here used Rackspace?



    (Going to investigate ajbrun's idea before I totally give in though...)
    1.21 GIGAWATTS!!!!!

  11. #11
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,147
    Thanks
    798
    Thanked
    2,151 times in 1,407 posts

    Re: Help connecting to a remote MySQL server...

    If the ODBC driver dosen't exist on the box, and you don't have rights to install it... your not going to have a nice time.
    throw new ArgumentException (String, String, Exception)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VPN Server 2003 and DG834GT
    By pcpower in forum Networking and Broadband
    Replies: 1
    Last Post: 21-08-2007, 08:37 PM
  2. Microsoft Small Business Back Office Server 2000
    By Pazza in forum SCAN.care@HEXUS
    Replies: 3
    Last Post: 17-06-2006, 12:32 PM
  3. Quick question about DHCP server in Win Server 2003
    By latrosicarius in forum Networking and Broadband
    Replies: 8
    Last Post: 24-05-2006, 06:07 PM
  4. Semi Debate/Open Chat/Questions - a True Server....
    By DR in forum PC Hardware and Components
    Replies: 8
    Last Post: 28-06-2005, 12:51 PM
  5. Replies: 6
    Last Post: 16-10-2003, 12:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •