CodeIgniter Forums
Connect using SQLSRV - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Connect using SQLSRV (/showthread.php?tid=77040)



Connect using SQLSRV - philfry - 07-14-2020

I'm trying to use the CI way of connecting to databases. It seems to work with mysql databases using mysqi. However, I get an error 1064 when using it to connect to SQL. I have set the connection up as sqlsrv driver. If I build the query using the php sqlsrv functions it works fine. Is there a trick to get this to work. It worked fine with the older version of PHP 5.x with the mssql driver.


RE: Connect using SQLSRV - php_rocs - 07-14-2020

@philfry,

What version of CI are you using? Can we see the code that is throwing the error?