Martint Posted March 24, 2006 Report Share Posted March 24, 2006 Well, this doesnt really belong in the webdesign section so I i'll just post it here.Ok heres my issue.My friend has a dedicated server at host A.He also have a web server at host B.He wants to connect to the mySQL server in his host A with php from host B.BUT he cant do this until he allows the host A's IP to connect to host B.But he doesnt know how to do it. It's on a Windows Server 2003 OS so no cpanel.He also don't have Plesk.Any idea how to do this?I'm guessing we have to do something with my.ini? Quote Link to post Share on other sites
Dragon Posted March 24, 2006 Report Share Posted March 24, 2006 this should help, it's from MS. There are a few steps in making this happen, so make sure you click next task in lesson to continue on until you have it all. Connecting from Another Computer Quote Link to post Share on other sites
Martint Posted March 24, 2006 Author Report Share Posted March 24, 2006 Er, I think thats for MSSQL, I need a tutorial for MYSQLThanks for the link though Quote Link to post Share on other sites
Dragon Posted March 24, 2006 Report Share Posted March 24, 2006 the process will be the same, from what i am understanding in your original post, you need to connect server A which has the DB to server B. thsi is all done with port forwarding, and the connections established with the DB system.don't assume that just because the writer works for MS it will only work on their systems. besides if you look at your MS windows XP installation you will see it uses mySQL for it's db tables. not a MS Access. Quote Link to post Share on other sites
Martint Posted March 24, 2006 Author Report Share Posted March 24, 2006 got damn, lol, I would never thought that microsoft will be well that *cant get the word * Quote Link to post Share on other sites
naraku9333 Posted March 25, 2006 Report Share Posted March 25, 2006 besides if you look at your MS windows XP installation you will see it uses mySQL for it's db tables. not a MS Access.Are you sure about that? MySQL is a GPL'd application, I would think MS would run into licensing issues. Quote Link to post Share on other sites
Dragon Posted March 25, 2006 Report Share Posted March 25, 2006 besides if you look at your MS windows XP installation you will see it uses mySQL for it's db tables. not a MS Access.Are you sure about that? MySQL is a GPL'd application, I would think MS would run into licensing issues.can't run into licensing issues if you change it enough where GPL isn't a status anymore. They use Oracle which is based off of mySQL. We have a locale Oracle office here. I talked to one of their Techs and he confirmed it. all it is, is MySQL rebranded and Licensed. Quote Link to post Share on other sites
jcl Posted March 25, 2006 Report Share Posted March 25, 2006 (edited) They use Oracle which is based off of mySQL.Oracle is at least 15 years older than MySQL. I doubt that Microsoft uses either of them for anything except compatibility testing and competitive analysis.I talked to one of their Techs and he confirmed it. all it is, is MySQL rebranded and Licensed.He's full of it. Edited March 25, 2006 by jcl Quote Link to post Share on other sites
Dragon Posted March 25, 2006 Report Share Posted March 25, 2006 I find that hard to believe that he is full of it, first off, if you look in Windows you will see the db configs, Driver=C:\WINDOWS\System32\odbcjt32.dllSetup=C:\WINDOWS\System32\odbcjt32.dllThose are Oracle he has been dealing in DB's for 25 years, so if he is full of it, then blame his IT school. Quote Link to post Share on other sites
jcl Posted March 25, 2006 Report Share Posted March 25, 2006 (edited) I find that hard to believe that he is full of it, first off, if you look in Windows you will see the db configs, Driver=C:\WINDOWS\System32\odbcjt32.dllSetup=C:\WINDOWS\System32\odbcjt32.dllThose are OracleThat's the Open Database Connectivity (ODBC) driver for Access, dBase, Excel, Paradox, and text databases. Edited March 25, 2006 by jcl Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.