in reply to Colon in server name breaks FreeTDS

I don't see how you have come to the conclusion that colons (in this case) "breaks DBD::ODBC". The error is reported by SQL Server as in:

[FreeTDS][SQL Server]

and the last string (on the right) in [] is the component reporting the problem.

  • Comment on Re: Colon in server name breaks DBD::ODBC

Replies are listed 'Best First'.
Re^2: Colon in server name breaks FreeTDS
by dbmathis (Scribe) on Jun 24, 2009 at 13:48 UTC

    Ok, great, now I know it's not ODBC reporting the issue, which I suspected all along because would would DBD care was SQL Server is doing.

    Anyone know how to get around this?

[reply]
      dbmathis:

      A couple suggestions:

      • It might be that the ':' in the server name could be converted to a '?' as part of the placeholder handling. If that's the case, using placeholder syntax instead of building the SQL on the fly should work nicely.
      • Perhaps SQL server doesn't like the name with a colon in it? (I've never seen a server name with a colon in it.) If that's the case, you could rename the server or create an alias for the server.
      ...roboticus
[reply]
[reply]

In Section Seekers of Perl Wisdom