[rt.cpan.org #58988] Restricted characters in servername

[Tom Cameron via RT]

Wed Jun 30 13:50:33 2010: Request 58988 was acted upon.
Transaction: Ticket created by tomtom
       Queue: Win32-ODBC
     Subject: Restricted characters in servername
   Broken in: 0.034
    Severity: Important
       Owner: Nobody
  Requestors: tcame...@cox.net
      Status: new
 Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=58988 >


Hi there,

I'm trying to use Win32-ODBC-0.034 in Activestate Perl 5.6.1 on WinXP to
create DSNs for MSSQL, where my connection string requires a port number
(the instance is not running on the default port of 1433).  For example:

my $result = Win32::ODBC::ConfigDSN(ODBC_ADD_SYS_DSN, "SQL Native Client",
        (       "DSN=test_dsn",
                "SERVER=myservername\\myinstancename,2815",
                "DATABASE=test_db"      )
);

I'm getting an error [911] [] "Illegal use of reserved characters
[]{}(),?*!@;", regarding the comma in the connection string.  Creating a
DSN manually using odbcad32.exe, a server name in the form
"myservername\myinstancename,2815" is legal (and required in my situation).

Can you provide a fix, or suggest a workaround?

Thanks,
Tom