Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Difficulty Connecting to MS-SQL server in Linux

by mpeppler (Vicar)
on Jul 14, 2007 at 06:35 UTC ( #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
      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!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://626591]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2020-11-24 07:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?