CodeIgniter Forums
MSSQL SERVER remote connection - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forum-5.html)
+--- Forum: Installation & Setup (https://forum.codeigniter.com/forum-9.html)
+--- Thread: MSSQL SERVER remote connection (/thread-78839.html)



MSSQL SERVER remote connection - payusice - 03-17-2021

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! [Image: smile.png]


RE: MSSQL SERVER remote connection - php_rocs - 03-17-2021

@payusice,

We need more information. What version of CI are you using? Also, CI connects directly to the DB (assuming it is configured correctly).
CI4 (https://codeigniter.com/user_guide/database/index.html)
CI3 (https://codeigniter.com/userguide3/database/connecting.html?highlight=database).