Re: ANY ONE CAN TELL ME WHAT PORT mssql_connect uses?

On Tue, 15 Jul 2003 19:36:42 +0300, you wrote: >how can i specify the port for the direct connection >mssql_connect() I've never had the need to do this, so I cannot verify that this works, but I believe you can supply a port number in the servername argument: mssql_connect('192.168.0.1:1433', 'someuser', 'somepass'); You can also define this in the FreeTDS "interfaces" file, I believe, but again I'm not sure as I use the default port. >can u give me some hints regarding the FreeTDS Read this article, it helped me out immensely when I set it all up: http://www.phpbuilder.com/columns/alberto20000919.php3 >if i used it then i have to confugure the DSN in liunx am i wrong? Not sure what you mean here. If you're referring to a Windows "Data Source Name" then that is not really relevant on a Linux platform. If you have access to port 1433 on the SQL server all you need to do is to download and install FreeTDS (follow the article above for help, and when all else fails read the FreeTDS documentation), then rebuild PHP with the "--with-sybase" option. After you have done that you can simply supply an IP address or hostname to the mssql_connect() call. Give it a shot and if you run into problems I'd be glad to try an answer any specific questions you may have.