freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: DBD::Sybase FreeTDS connection problems to MS S QLServer 6.5

From: "Geoff Winkless" <geoff AT farmline.com>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Subject: Re: DBD::Sybase FreeTDS connection problems to MS S QLServer 6.5
Date: Thu, 12 Oct 2000 12:47:40 +0100

X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400

"Andy" <anwill AT acxiom.co.uk> writes:
> Looks like the following:
>
> JDBC
> query tcp ether 192.138.151.39 4444
> master tcp ether 192.138.151.39 4444
>
> myserver
> query tcp ether 127.0.0.1 4000
> master tcp ether 127.0.0.1 4000
>
> myserver2
> query tcp ether 127.0.0.1 4001
> master tcp ether 127.0.0.1 4001

By default SQL Server runs on port 1433...

you should set up this file to have an entry

machinename
query tcp ether 10.150.3.210 1433
master tcp ether 10.150.3.210 1433

Of course, replace machinename with whatever you want to use, and then
reference -that- name in the perl code:

my $dsn = "dbi:Sybase:database=myDB;server=machinename";

Geoff

Re: DBD::Sybase FreeTDS connection problems to MS S QLServer 6.5, anwill - Andy Williams, 10/12/2000
- <Possible follow-up(s)>
- Re: DBD::Sybase FreeTDS connection problems to MS S QLServer 6.5, Geoff Winkless, 10/12/2000