Member Avatar for dza

Hi guys

Our college has a website(php, html, css) that is hosted elsewhere, but now we have a college database (mssql) on a local server and the Director wants me to link the website to the database at the college's server.

Any ideas on how to do that?

thanks in advance

  • 3 Contributors
  • 3 Replies
  • 106 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by CarterLangley

Recommended Answers

All 3 Replies

Member Avatar for pritaeas

The server where the database is needs to allow remote connections. Your router/firewall needs to allow the website host to connect/reroute. Then you can open the database server by ip address or hostname on the host. Check first with your web host, to see that there are no limitations that prevent this.

Member Avatar for dza

thanks a lot hey, even if i re do the site in wordpress, i still have to do it the same way u mentioned above huh?

but thanks so much

Member Avatar for CarterLangley

Can you access the mysql database on the local server? If so, then just adjust the code on the html site to point to that database. Get the server dude at your college to give you / your site the necessary permissions and let you know what they are.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.