FreeTDS Development Group

["Frank M. Kromann" <frank AT kromann.info>]

Hi Patrick,

Ok I get it now. I think I was confused about your statement about not
being able to conenct via IP. That's why I started talking about named
pipes (the alternative that only exists with MS native library).

I think I can give you the way to connect now. Create something like this
in your freetds.conf file:

[bor-gen]
  host = bor
  instance = gen
  port = 1433
  client charset = UTF-8
  tds version = 8.0
  text size = 20971520

and then use mssql_connect("bor-gen", $user, $pass); in your script.

if you have multiple instances you need a server entry for each of them in
freetds.conf.

- Frank

> 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
> >
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>