Win32::SqlServer is a module that permits you to access Microsoft SQL Server from Perl through OLE DB. Win32::SqlServer is designed to be the prime alternative when you need to access SQL Server from Perl on Windows, and you have no interest to access any other RDBMS. That is, it does not run on Unix, and there is no support for DBI. To see Win32::SqlServer in action, take at look the quick examples in the Win32::SqlServer manual.
To download this module here is the file: Win32-SqlServer-2.015.zip (1020 KB). The zip file includes 32-bit and 64-bit binaries for Perl 5.32, 5.34, 5.36, 5.38 and 5.40. These binaries run with Strawberry Perl with the caveat at the time of this writing the most recent release of Strawberry Perl was 5.38. Based on past experience, they should also run with ActiveState Perl, but this version has not been tested with ActiveState Perl.
Quick install instruction for the binary versions.
perl win32-sqlserver-install.pl. Note that the name of the installation script is different from Win32::SqlServer 2.011 and earlier.For more detailed instructions, including the full set of prerequisites, see the README (also included in the zip file).
The manual is included in the zip file, but you can also read it here:
The manual is long, over 90 pages when printed, but there are plenty of examples in it.
You can also view the revision history.
The story about Win32::SqlServer is highly dependent on three men: Larry Wall (of course). Michael Peppler who wrote the original Sybperl, and Christian Mallwitz of Intershop Gmbh who took the effort to port Sybperl 2.03 to Windows NT. From that work I was able to develop MSSQL::DBlib, and without that an entrance point into the XS world, I would not have been able to write Win32::SqlServer.