Sign here if you use SQL Server

[eluser]whobutsb[/eluser]
No i'm not using the SQLSRV library, but I do have MSSQL Driver installed on my PHP setup.

[eluser]JulianM[/eluser]
Ok, yes, I think we used different approaches, I just read your other comment here:
http://ellislab.com/forums/viewthread/78909/#527477

I had the same problem, not remember exactly about the LIMIT function but I had other troubles with MS SQL. Hopefully now I run it for a medium/large project successfully.

I have used sqlsrv library but I needed to modify the original drivers for codeigniter.

For example, one challenge I had was concerning Windows Authentication, I could not run it with SQL Server Authentication, but given that SQL Server Driver for PHP supports Windows Authentication only, then it worked like a charm.


[quote author="whobutsb" date="1233891662"]No i'm not using the SQLSRV library, but I do have MSSQL Driver installed on my PHP setup.[/quote]

[eluser]Alejus[/eluser]
Hi Everybody !

I´m new with CI, but I was develop with PHP since a years ago.

I must to migrate an entire project developed with MySQL db to MsSQL and is my idea do it with CI.

Can you tell me if is correct to do with it ?

Thanks a lot for your time.

PolloLetal
From a place in SouthAmerica

[eluser]JulianM[/eluser]
Hi Alejus.

Go ahead. It is ok to use MSSQL (I have used SQL Server 2005 in a previous project)

Julian

[quote author="Alejus" date="1235509832"]Hi Everybody !

I´m new with CI, but I was develop with PHP since a years ago.

I must to migrate an entire project developed with MySQL db to MsSQL and is my idea do it with CI.

Can you tell me if is correct to do with it ?

Thanks a lot for your time.

PolloLetal
From a place in SouthAmerica[/quote]

[eluser]riza_nurhadi[/eluser]
im using CI 1.6 with sql server 2005 on different server
and only use mssql with changed ntwdblib.dll

it works well but...the connection to database is unstable..
sometimes its display error "unable to connect databse...."

in the previous web application, still PHP and SQLServer 2005 but without CI and not made by me,
its using php COM class and ADODB object to connect to database...
i wonder is this really the solution

after few googling i found SQL Server Driver for PHP made by MS.
i try it once but it goes blank....

oh well, im gonna try SQL Server Driver for PHP again..

[eluser]riza_nurhadi[/eluser]
im using COM class and ADODB Object to connect SQL Server 2005.

Code:

class ADODB {

        var $ado_data_source = '192.168.1.1';
        var $ado_db_name = 'thisisdb';
        var $ado_db_uid = 'sa';
        var $ado_db_pwd = 'iforgot';

function adodb_query_execute($sql){
         $conn = new COM("ADODB.Connection") or die("Cannot start ADO");
         $conn->Open("Provider=SQLOLEDB; Data Source=".$this->ado_data_source.";
         Initial Catalog=".$this->ado_db_name."; User ID=".$this->ado_db_uid."; Password=".$this->ado_db_pwd."");
         $conn->Execute($sql);
         $conn->Close();
         $conn = null;
       }
}

[eluser]Mr.Puth[/eluser]
why I can not connect to MS SQL Database when I have alots of user? Error message : Unable to connect database using this provider setting.