FreeTDS Development Group

["Patrick Corbett" <pcorbe81 AT maine.edu>]

Right, I was a bit confused on my end as well as far as whether I was using
named pipes or named instances, but it's definitely a "named instance" or
just "instance". So I reference it in my PHP connection string the following
way:

$host = "server\instance";
mssql_connect($host, $user, $pass);

So... the question is can I use named instances or are those not supported
along with named pipes?

Frank gave me a few tips that I'll try out this morning, but let me know if
I'm wasting my time. Unfortunately, I am stuck with referencing my server
this way and I also can't change the way I connect via PHP either.

Thanks for all your help... and Frank, didn't mean to go behind your back or
anything, I'm just desperate :)

Thanks guys,

Patrick


On 4/12/07, James K. Lowden <jklowden AT freetds.org> wrote:
> Frank M. Kromann wrote:
> > If I understtod Patricks original problem correct he's looking for a way
> > to connect using named pipes and not tcp/ip.
>
> Hi Frank,
>
> Not sure where you got that?  Something he said to you?  His post here
> said "named instance".  That's the 2000 feature that lets several
> "instances" of the server run on the same machine, listening to different
> ports.
>
> > FreeTDS does not support named pipes afaik?
>
> AFAIK, too.  ;-)  I can't see a reason even to think about adding them.
>
> Regards,
>
> --jkl
>
> > > Patrick Corbett wrote:
> > > > I was speaking ealier to Frank Kromann about using FreeTDS on a
> > windows
> > > > machine with PHP in order to avoid an issue that limits data pulled
> > from
> > > > SQL Server 2000 with PHP from a varchar field to 255 characters
> > > > using php_mssql.dll. Normally, I would use Kromann's php_dblib.dll
> > > > to fix this, but because apparently this library doesn't allow named
> > instances
> > > > for a server name in the freetds.conf file, and because I have to
> > > > connect to my server with named instances (e.g.,
> > server\instance_name),
> > > > I'm not sure what I can do.
> > >
> > > http://www.freetds.org/userguide/freetdsconf.htm#FREETDSCONFFORMAT
> > >
> > > Just put the instance name in freetds.conf and make sure you're using
> > TDS
> > > version 7.0 or 8.0.
> > >
> > > It took me a minute to understand your question.  Then I understood:
> > > if you use Microsoft's ntwdblib.dll, you get TDS version 4.2, which
> > > limits varchars to 255 characters.  If you use FreeTDS, you get an
> > > updated protocol and 8000-byte varchars.
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds