# [freetds] Named Instances

Patrick Corbett pcorbe81 at maine.edu
Tue Dec 18 17:04:22 EST 2007

Yes, very close... I'm on a windows machine, do you think I need to download
a specific build of php for this? I simply got my copy from php.net and got
the windows build of it. I then went to kromman.info and downloaded the
php_dblib.dll and loaded that up in my php.ini.

Perhaps I'm doing something wrong there?

On 12/18/07, James K. Lowden <jklowden at freetds.org> wrote:
>
> Patrick Corbett wrote:
> > I did a little more testing and was able to get a (better?) error
> > message:
> >
> > freedts.conf
> > -------
> > [abc\def]
> > instance = def
> > port = 1197
> > client charset = UTF-8
> > tds version = 8.0
> > ;text size = 20971520
> > dump file append = yes
> > dump file = C:\Inetpub\wwwroot\freetds.log
> > --------
> ...
> > config.c:251:Success: [abc\def] defined in c:\freetds.conf.
>
>         So far so good....
>
> > net.c:185:Connecting to 204.228.89.23 port 1197 (TDS version 8.0)
> > net.c:240:connect(2) returned "Unknown error"
>
>         Oh, so close!
>
> > I know this wasn't the config setup you had suggested, but it seems to
> > give a "better" error message than before...
> ...
> > what do you think I could do to convince my DB Admin to allow me
> > to reference an IP
>
> If you try that and he has any sense, he'll send you down the hall to the
> DNS guys, because they're the ones who assign names to numbers.  The
> database server -- any server -- doesn't know or care how you got its
> address.  All it knows is you showed up with a packet asking for a
> connection to such-and-such a port.
>
> You can just change your freetds.conf thus:
>
> + host = a.b.c.d
>
> where a.b.c.d is the internal address you want to connect to.  That's
> valid.
>
> To make your life easier, I'd ask the DNS folks to assign a name to that
> number.  It could be (if they want) abc.internal.adomain.com.  They might
> already have done so, btw.  You could check with:
>
>         \$ nslookup a.b.c.d
>
> HTH.
>
> --jkl
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>