| Subject: | Restricted characters in servername |
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