Win32::SqlServer 2.014

Brief Overview

Win32::SqlServer is a module that permits you to access SQL Server from Perl, by using any of Microsoft's OLE DB providers for SQL Server. Win32::SqlServer exposes two levels of interface, a high-level interface and a mid-level interface. The mid-level interface exposes a few more knobs at the price of somewhat more verbose code. A special feature of Win32::SqlServer is that you get fine-grained control for error handling.

There is no support for DBI. This module does not run on Unix – or any other non-Windows OS for that matter.

Prerequisites

For details, see the Prerequisites section in the Win32::SqlServer manual.

Prerequisites for building, see below under Building from Sources.

Support for Older Platforms

If you need support for older platforms than listed above, you can use an older version of Win32::SqlServer as follows:

What's in This Kit

This is the source-only distribution for CPAN, and do not include any binaries for Win32::SqlServer. If you want a binary distribution (for x86 or AMD64) please visit http://www.sommarskog.se/mssqlperl/index.html.

Manual

The manual is in Win32-SqlServer.html. There is a POD file as well, but there is no real contents in it, only a pointer to the HTML file.

Reporting Bugs or Problems

Please mail bug reports and suggestions to [email protected]. Try to make your reports as specific as possible. Particularly do not forget to include which versions of Perl, Windows, SQL Server etc you are using.

I usually try to respond within 24-48 hours, but if I am on holiday I am.

Building from Sources

Prerequisites

To build Win32::SqlServer you need:

If you want to build Win32::SqlServer with another compiler than Visual C++, you are welcome to try. I am certainly interested to know if you succeed, but I am afraid that I cannot give any help in the matter – it's way beyond my realm. (I'm an SQL Server guy, after all.)

Note that the Perl environment you build in, should have been configured with the same compiler as you are using. That is, you cannot build Win32::SqlServer using Visual Studio with Strawberry Perl, or ActivePerl 5.18 or later, as they are configured with gcc.

How to Build and Install

Text in this type face indicates command you run from the command prompt.

  1. Extract the zip file anywhere you like.
  2. Edit makefile.pl so that $SQLDIR points to where the SDK for Microsoft OLE DB Driver for SQL Server is located.
  3. If you use a different compiler from Visual C++, you need to review makefile.pl more closely as makefile.pl may include options that are specific to Visual C++.
  4. Note that makefile.pl explicitly lists which libraries to link with, and specifies the MT flag for the C compiler. This is to force use of the static C run-time library for Visual C++, which is what I want for the binary distribution. Change this if you like.
  5. Open a Command Prompt, and change directory to where you extracted the files.
  6. Perl makefile.pl.
  7. MAKE
    Or NMAKE, DMAKE or whatever your MAKE utility you use.
  8. MAKE test
    Before you run the tests, please read tests.html so that you understand what impact the test scripts have on your server. This document also describes how to set the environment variable OLLEDBTEST, from which the test scripts get information how to log into SQL Server.
  9. MAKE install

Last updated 22-05-29 20:35