Welcome Guest, Not a member yet? Register   Sign In
Codeigniter MYSQL MSSQL SERVER remote connection
#1

Hello CodeIgniter Community.

I am having a challenge in connecting to the database.

So here is my scenario.

My client has an existing database. It is a MS SQL Server database. It is a local database. 

Now my project is to create a web app to connect to that database. The web apps purpose is to show reports to the user. 

Do you have any idea how can I connect from cpanel? 

So the connection would be mysql (online) to ms sql server (local intranet). Or can I connect directly to ms sql server? 

Do you have any idea or suggestions how to implement this? Thanks! Any suggestion would be appreciated! Smile
Reply
#2

You are required to open the firewall on the intranet MS SQL SERVER. That server needs a public IP-address. And make sure to only allow your host servers IP-address. After that just specify the public IP-adress and Username/Password in your Codeigniter configuration everything should be good to go.

If you aren't on a public server, but VPS you can always use a VPN connection or similar instead of opening the whole server up to the world.

If you don't require real time data. (or you aren't allowed to open ports) And have a MS SQL server on your Cpanel hosting company, you can also schedule a database dump, SSH/FTP it over, import it with cron and then display it with Codeigniter.

The last option are to install a local webbserver (and connect it to the world) and connect to the local MS Server from there.
Reply




Theme © iAndrew 2016 - Forum software by © MyBB