Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: Difficulty Connecting to MS-SQL server in Linux

by mpeppler (Vicar)
on Jul 14, 2007 at 06:35 UTC ( [id://626591]=note: print w/replies, xml ) Need Help??


in reply to Difficulty Connecting to MS-SQL server in Linux

I believe you are trying to connect to what is known as a named instance. This was recently added to FreeTDS (supported by FreeTDS in the current release, I think). If you don't have the latest version of FreeTDS you should probably upgrade (or ask on the FreeTDS mailing list.)

Michael

  • Comment on Re: Difficulty Connecting to MS-SQL server in Linux

Replies are listed 'Best First'.
Re^2: Difficulty Connecting to MS-SQL server in Linux
by MegaVoice (Novice) on Jul 16, 2007 at 14:43 UTC
    Michael,

    I am running the latest stable version of FreeTDS (0.64) and submitted a question to their mailing list. I might be able to connect via ODBC, but I remain hopeful that the FreeTDS mailing list might have some insight.

    Thank you,
    Sean
[reply]
      Got it! I had the host that the server resided on. I was able to update the connection string to the following:

      my $dbh=DBI->connect("DBI:Sybase:host=<hostname>;port=2832",$user,$password);

      Since the hostname didn't have a slash in it, I was able to use the port that the server was using. I was able to connect so that I can continue testing.

      I appreciated the comments!
[reply]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://626591]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others admiring the Monastery: (2)
As of 2024-04-26 03:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found