[Cialug] php/mssql connection issues

[Laith Preston]

ok, it is resolved now. it was a stupid permissions issue, the webserver 
site process was not running as the correct user for mixed to work

Tony Bibbs wrote:
> 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
>>   
>>     
>
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>