Re: [PHP] specifying different port for db connections
mssql_connect() establishes a connection to a MS SQL server. The servername argument has to be a valid servername that is defined in the 'interfaces' file. -- this is what i am referring too This is my connection string MSSQL_CONNECT(192.168.10.1 2461,$username,$password) or DIE(DATABASE FAILED TO RESPOND.); Attemping to use an interfaces file have been unsuccessful. I'm still baffled that there isn't a way to specify the port in the connection sting. Thanks for your help __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] specifying different port for db connections
Not a big mssql guy but if i remember correctly that should be set in your interfaces file...but a valid server name should be used and that is checked in the interfaces file... On Thu, 2002-11-07 at 20:12, heath boutwell wrote: Attempting to access remote db (SQL Server) how do you specify the port? I've tried everything in the hostname paramater of mssql_connect but nothing seems to work. ie none of the following: MSSQL_CONNECT(192.168.10.1,2461,$username,$password) or DIE(DATABASE FAILED TO RESPOND.); or MSSQL_CONNECT(192.168.10.1:2461,$username,$password) or DIE(DATABASE FAILED TO RESPOND.); or MSSQL_CONNECT(192.168.10.1;2461,$username,$password) or DIE(DATABASE FAILED TO RESPOND.); Thanks __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- .: B i g D o g :. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] specifying different port for db connections
--- .: B i g D o g :. [EMAIL PROTECTED] wrote: Not a big mssql guy but if i remember correctly that should be set in your interfaces file...but a valid server name should be used and that is checked in the interfaces file... I think the interfaces file is only used if you are accessing sql server from the same machine. In this case, I am attempting to connect remotely. Hard to believe that changing the connection port would be such a mystery but nothing I've read or tried seems to work. Thanks __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] specifying different port for db connections
Actually the remote file is used if you are trying to connect to a remote system. Sybase uses remote files and that is how it works...i know oracle does a similar way of connecting... IMHO, i would look into the interface file and change it there... On Thu, 2002-11-07 at 21:55, heath boutwell wrote: --- .: B i g D o g :. [EMAIL PROTECTED] wrote: Not a big mssql guy but if i remember correctly that should be set in your interfaces file...but a valid server name should be used and that is checked in the interfaces file... I think the interfaces file is only used if you are accessing sql server from the same machine. In this case, I am attempting to connect remotely. Hard to believe that changing the connection port would be such a mystery but nothing I've read or tried seems to work. Thanks __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- .: B i g D o g :. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] specifying different port for db connections
--- .: B i g D o g :. [EMAIL PROTECTED] wrote: Actually the remote file is used if you are trying to connect to a remote system. Sybase uses remote files and that is how it works...i know oracle does a similar way of connecting... IMHO, i would look into the interface file and change it there... There is no interface file on the system utilizing php. Using MySQL, you can set the mysql.default_port configuration option to specify the port you wish mysql_connect to use. There should be a way to do this in the via the host paramater in the connection string. Thanks __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] specifying different port for db connections
Which database are you using? MSSQL is what you said in your first email... Here is the information from php: Description int mssql_connect ( [string servername [, string username [, string password]]]) Returns: A positive MS SQL link identifier on success, or FALSE on error. mssql_connect() establishes a connection to a MS SQL server. The servername argument has to be a valid servername that is defined in the 'interfaces' file. -- this is what i am referring too In case a second call is made to mssql_connect() with the same arguments, no new link will be established, but instead, the link identifier of the already opened link will be returned. On Thu, 2002-11-07 at 23:02, heath boutwell wrote: --- .: B i g D o g :. [EMAIL PROTECTED] wrote: Actually the remote file is used if you are trying to connect to a remote system. Sybase uses remote files and that is how it works...i know oracle does a similar way of connecting... IMHO, i would look into the interface file and change it there... There is no interface file on the system utilizing php. Using MySQL, you can set the mysql.default_port configuration option to specify the port you wish mysql_connect to use. There should be a way to do this in the via the host paramater in the connection string. Thanks __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- .: B i g D o g :. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php