Re^3: Colon in server name breaks FreeTDS

[roboticus]

in reply to Re^2: Colon in server name breaks FreeTDS
in thread Colon in server name breaks FreeTDS

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

[mje]

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.

[dbmathis]

I just added new links to sys.servers without the colon and it fixed the issue.