FreeTDS with PHP on OSX?
Gabriel Ricard
gricard at mac.com
Sun Jun 24 08:28:14 EDT 2001
On Saturday, June 23, 2001, at 08:52 PM, James K. Lowden wrote:
> Hi Gabriel,
>
> gricard at mac.com wrote:
>
>> I've got a system running OSX. I managed to get FreeTDS compiled
>> and installed and then compiled PHP 4.0.5 with the FreeTDS libraries. I
>> cannot seem to get it to connect to the DB. I need to connect to an MS
>> SQL Server running 6.5. It appeared from the documentation that I
>> should
>> use version 4.2, which I am. My interfaces entry looks like this:
>>
>> mssqldb
>> query tcp tds4.2 a.b.c.d 1433
>> master tcp tds4.2 a.b.c.d 1433
>
> Your configuration is known to work; it's almost certainly a
> configuration issue.
> Yes, 4.2 is the right protocol version for SQL Server 6.5.
>
> Your query line should be:
> query tcp 4.2 a.b.c.d 1433
Ok, I'll try that.
> (per the docs, not the sample file)
>
> Also, "a.b.c.d" should be either the data server's ip address or its
> hostname. When
> you're telling PHP which data server to use, you provide the symbolic
> name ("mssqldb"
> in your case). FreeTDS will find the symbolic name in the interfaces
> file and
> establish a connection to the machine designated by "a.b.c.d".
>
> You'll want to make sure you can reach "a.b.c.d" with ping, and you
> should be able to
> connect to the port -- if the server's up and listening -- with "telnet
> a.b.c.d
> 1433". I don't remember offhand what the default port is for 6.5, but
> you'll want to
> be sure of that, too.
>
Yep, I can ping and telnet in.
> Welcome to FreeTDS. Let us know how it goes.
>
> --jkl
>
> P.S. The advice to try Sqsh if you need to troubleshoot your
> connection is well
> founded, but I wonder: Does it install/run in OSX
What is Sqsh?
>
> ---
> You are currently subscribed to freetds as: [gricard at mac.com]
> To unsubscribe, forward this message to leave-
> freetds-132487T at franklin.oit.unc.edu
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 2011 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20010624/6e89e294/attachment.bin
More information about the FreeTDS
mailing list