[Cialug] php/mssql connection issues

Tony Bibbs tony at tonybibbs.com
Tue Oct 31 09:34:33 CST 2006


FWIW, at work all our PHP->MSSQL apps use freeTDS.  Of course that
assumes you are running *nix on the web server. 

--Tony

Tony Bibbs wrote:
> You got sybase or sybase-ct compiled into php?  If not you'll want one
> of them.
>
> --Tony
>
> Dave J. Hala Jr. wrote:
>   
>> Try doing:
>>
>>  $db = mssql_connect($host,$user,$pass) or die (mysql_error());
>>
>> This should return the error message. That will give you a good place to
>> starting looking.
>>
>>
>>
>>
>> On Mon, 2006-10-30 at 16:51, Laith Preston wrote:
>>   
>>     
>>> I am having a problem connecting to an MSSQL server from php on a IIS 
>>> installation. I know... I know... project requirements.
>>>
>>> anyway
>>> If I connect to an named DSN using the odbc connection functions it 
>>> works, but if I try to connect to it using the mssql functions it fails, 
>>> I am uncertain if the client will allow for use of the odbc
>>>
>>> $db  =  mssql_connect($db_host,$db_user,$db_pass);
>>>
>>> $db2    = odbc_connect($db_dsn,$db_user,$db_pass);
>>>
>>>
>>> any thoughts?
>>>
>>> Thanks
>>> Lathrop
>>>
>>> _______________________________________________
>>> Cialug mailing list
>>> Cialug at cialug.org
>>> http://cialug.org/mailman/listinfo/cialug
>>>     
>>>       
>
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>   



More information about the Cialug mailing list