[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