[freetds] dbi:sybase:server SQL Server connection issue serve rname\instancename
dba_1_1 at yahoo.com
Mon Oct 11 11:31:49 EDT 2004
Thank you. I will find out what port it is listening on an then make the entry. Is the port assignment static or does it change with each bounce of the sql server?
"Bort, Paul" <pbort at tmwsystems.com> wrote:
Instances are really just SQL servers listening on a different port.
If you set up the server in freetds.conf, you can alter the default port,
then use the entry in freetds.conf to connect.
You may have to use Enterprise Manager to discover what port has been
assigned to the instance you are looking for.
name = sql.foo.com
tdsver = 8.0
port = 1435
In your program:
$dbh = DBI->connect("dbi:Sybase:server=SQLINSTANCE", $user, $pass )
or die "Can't connect: " . DBI->errstr;
> -----Original Message-----
> From: Kirk Anderson [mailto:dba_1_1 at yahoo.com]
> Sent: Monday, October 11, 2004 11:00 AM
> To: freetds at lists.ibiblio.org
> Subject: [freetds] dbi:sybase:server SQL Server connection issue
> Problem connecting with DBI and sql server using
> servername\instancename. I have had no issues connecting when
> the servername is used.
> Here is my connect :
> $dbh = DBI->connect("dbi:Sybase:server=wyn-dfwimobile2",
> 'userid', 'password') or die 'connect';
> I log into the sql database using sql query analyzer with the
> userid/password with no problems.
> I issue the select @@servername and get wyn-dfwimobile2\synchsql
> I issue hostname from the cmd prompt and get wyn-dfwimobile2
> I am unable to get the right combinations to connect to this
> sql server using DBI. What am I missing?
> Thanks in advance, Kirk
> Do you Yahoo!?
> vote.yahoo.com - Register online to vote today!
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
Do you Yahoo!?
vote.yahoo.com - Register online to vote today!
More information about the FreeTDS