Re^2: Colon in server name breaks FreeTDS

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?

Comment on Re^2: Colon in server name breaks FreeTDS

Replies are listed 'Best First'.
Re^3: Colon in server name breaks FreeTDS by roboticus (Chancellor) on Jun 25, 2009 at 16:15 UTC
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]
Re^4: Colon in server name breaks FreeTDS by mje (Curate) on Jun 26, 2009 at 07:31 UTC
If it was the first of the two things you mention then http://search.cpan.org/~mjevans/DBD-ODBC-1.22/ODBC.pm#odbc_ignore_named_placeholders could be used to ignore the colons but I don't think it is.	[reply]
Re^5: Colon in server name breaks FreeTDS by dbmathis (Scribe) on Jul 04, 2009 at 15:40 UTC
I just added new links to sys.servers without the colon and it fixed the issue.	[reply]