Re: [PHP-WIN] PHP and SQL 2000

2004-08-12 Thread PHP MySQL
hi list, I set mssql.secure_connection = On in php.ini file and my php file is now successfully getting connected to the SQL 2000 database. Thank u very much for ur helpspecial thanks to Frank. Regards, penjo Yahoo! India Matrimony: Find your life partneronline.

Re: [PHP-WIN] PHP and SQL 2000

2004-08-12 Thread Frank M. Kromann
Hello, The default way to connect is to use SQL Server user names and passwords, but the mssql extension can be configured to use secure/trusted connections. This is don by setting mssql.secure_connection = On in php.ini. With a secure connection the client maschine will use the userid/password f

[PHP-WIN] PHP and SQL 2000

2004-08-11 Thread PHP MySQL
hi there, i have been trying to connect to a sql 2000 server database. I am able to connect using the DSN-connection: i.e., the following code works: "; while (odbc_fetch_row ($process)) { $Description = odbc_result($process, "FullDescrp"); echo "$Description "; } odbc_close ($sqlconnect)