[Cialug] php/mssql connection issues

[Dave J. Hala Jr.]

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
-- 

Open Source Information Systems, Inc. (OSIS)
Dave J. Hala Jr., President <dave at osis.us>
641.485.1606