MSSQL on Web

[lucasabbud]

Hi, i'm using Mucore 1.0.8, with ODBC connection.

I'm using a template which has this:

$Sdaaq = mssql_query("SELECT count(*) FROM MEMB_STAT WHERE ConnectStat = '1'");
$online= mssql_result($Sdaaq, 0, 0);
//
$Sdaaq1 = mssql_query("SELECT count(*) FROM Guild");
$guild= mssql_result($Sdaaq1, 0, 0);
//
$Sdaaq2 = mssql_query("SELECT count(*) FROM Character");
$charac = mssql_result($Sdaaq2, 0, 0);
//
$Sdaaq3 = mssql_query("SELECT count(*) FROM MEMB_INFO");
$cues= mssql_result($Sdaaq3, 0, 0);

How do i change it to work with odbc??

Thanks!!

[MentaL]

[KarLi]

u cant change that on the template, u must use ODBC function in config.ini on mucore to make the website work with ODBC then, why u dont want to use MSSQL ? its faster and better.

[lucasabbud]

u cant change that on the template, u must use ODBC function in config.ini on mucore to make the website work with ODBC then, why u dont want to use MSSQL ? its faster and better.

I've SQL Server 2008 R2 Express version, does not have SQL Agent to run job.
How do I run it with mssql?

[KarLi]

Maybe u will have to install other SQL Version


Sent from my iPhone using Tapatalk

[fallenfate]

For 2008R2 you can use PHP sqlsrv() drivers and change mssql_query to sqlsrv_query, etc. But you need to download the drivers first.

Sqlsrv drivers download - https://www.microsoft.com/en-au/down....aspx?id=20098

You need to add them to your php.ini in order for them to work and then reboot Apache.