php-ms sql server connection

[Anon]

I have the following setup installet

1. LINUX with Apache Web Server and php 4.0
2. MS SQL Server 7.0 on Windows NT 4.0

Now i have an application coded in php residing on the linux box . I want to connect to the MS SQL Server 7.0 database residing on the NT server.

I tried estabilishing the connection by:
mssql_connect ("[dbname]","user id","pwd")

when executing the above, the following error occured:

"[dbname]" connection failed.

These are the measures i had taken care as per the instructions available on php.net and www.phpbuilder.com:

1. downloaded freeTDS software
2. changed the php.ini file
3. changed the interfaces file under the freetds directory.

Inspite of all the above, i could not connect to the server.
Could someone tell me the right procedure to connect to the database and if possible send me the syntax for the same.

[Anon]

I assume in the example you gave [dbname] is the name of the database in MS SQL 7 on your NT server. mssql_connect needs the server name, not the database name.

The connection command should be:

$connection = mssql_connect("server", "user", "pwd");

Then you would select the database with
$database = mssql_select_db("dbname", $connection);

Hope this helps

[Anon]

thanks for the reply.
i have done as instructed but iam getting the following error:

php warning: unable to load dynamic library './php_mssql70.dll - ./php_mssql70.dll:cannot open shared object file: no such file or directory in unknown on line 0

$db_conn=mssql_connect("hris","sa","")

could u please help me in identifying this problem....where on the linux server can i look for this dll?

thanks
kalyan

[Anon]

dll files are Windows only. For linux you should have a .so file. Try looking for an extension named sybase.so or sybase_ct.so

I haven't tried this particular setup myself, but as an alternative to the mssql functions you could try connecting with the unified ODBC functions (odbc_connect, etc.).