Skip Menu |
 

This queue is for tickets about the Win32-ODBC CPAN distribution.

Report information
The Basics
Id: 58988
Status: new
Priority: 0/
Queue: Win32-ODBC

People
Owner: Nobody in particular
Requestors: tcameron [...] cox.net
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 0.034
Fixed in: (no value)



Subject: Restricted characters in servername
Download (untitled) / with headers
text/plain 735b
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


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.