You can read Dave Roth's articles published in the Windows IT Pro magazine (formally known as Windows .NET Magazine) that use Perl to accomplish interesting tasks.

Win32::ODBC Documentation

An updated doc is available

Business Stuff

ODBC extension for Win32 PERL
Version 96.05.08
by Dave Roth (rothd@roth.net)

Based on code by Dan DeMaggio (dmag@umich.edu) -- Thanks Dan!

Back to the top

Copyright

Copyright © 1996 Dave Roth. All rights reserved.
This program is free software; you can redistribute it or modify it under the same terms as PERL itself.

Back to the top

Disclaimer

I do not guarantee ANYTHING with this package. If you use it you are doing so AT YOUR OWN RISK! I may or may not support this depending on my time schedule and I am neither an SQL or ODBC guru so do not ask me questions regarding them!

Back to the top

GNU General Public License

Coming soon....

Back to the top

Larry Wall's "Artistic License"

Artistic License

Back to the top

Version History

ODBC.PM

Date	Changes
96.03.27	Initial Release (rothd)
96.04.08	Changed Data() to accept an array of field names, returning an array or scalar (joc)
96.04.08	Various bug fixes (joc)
96.04.10	Fixed the RowCount() to default to the current connection (droth)
96.04.15	Changed version numbers to a date format (rothd)
96.05.07	Fixed Data(): If returning an array, the array consisted of the requested fieldnames + the values. Now only returns the values. Thanks to Dan Westerlund <westerlund@dkraft.se>! (rothd)
96.07.22	Added MoreResults(): Checks to see if there are any more records that have not been retrieved. (dunfordshore)
96.07.22	Changed Error(): Errors are tracked differently now. Any error will record the error number ($ErrNum) and error text ($ErrText) in the object's name space and can be retrieved by calling $Database->Error(). Error() will also return the ODBC connection number that caused the error. If the context of the call is not an array then a string with this information will be returned. The Win32::ODBC name space will always have the last error info made, even if it is an error returned by the new method. You can call Win32::ODBC::Error() to get that. (rothd)

ODBC.PLL

Date	Changes
96.04.10	Fixed a "memory bug": we were using SQL_CLOSE when closing an ODBC statement. This kept the cursor alive in memory so it can be cached in the event the same SQL statement is issued. We are now using SQL_DROP. This may lessen speed if the same SQL statements are issued again and again per connection. (rothd)
96.04.10	Cleaned up some code. (rothd)
96.04.12	Added GetStmtCloseType() and SetStmtCloseType() functions. (rothd)
96.04.12	Added some constants. (rothd)
96.04.13	** We now are trying to include a version for builds up to and including 105 and another for builds 106 and greater (for now).
96.04.15	Fix Bug in ODBCFetchRow(): when retrieving a field with a NULL value the value from the previous field was reported. (jmk)
96.04.15	Changed version numbers to a date format.
96.04.22	Fix the SDWORD wrap-around bug in ODBCFetchRow(): when a column of size 2147483647 adding 1 (for a NULL byte in szBuf) yields -2147483648 (not easy to "net UCHAR (-2147483648)"!!) (jmk)
96.04.22	Inspired by Jutta, I have increased the max limit for SetMaxBufSize() to 2,147,483,647 bytes. (rothd)
96.05.03	Set the lowest allocated char array to be 20 bytes in ODBCFetchRow(). Evidentally sometimes the ODBC manager will report too few chars that are needed to represent an autonumber field. (rothd)
96.05.08	Convert all results from ODBCTableList() to uppercase since different ODBC drivers impliment this differently (some uppercase some lower). Thanks again to Jutta M. Klebe. (rothd) * This patch is open for suggestions!!! *
96.07.22	Added ODBCMoreResults(): Checks to see if there are any more records that have not been retrieved. (dunfordshore)

Back to the top

Author List

Abbreviation	Name	EMail
rothd	Dave Roth	rothd@roth.net
joc	Joe Casadonte	joc@netaxs.com
jmk	Jutta M. Klebe	jmk@exc.bybyte.de
dunfordshore	Brian Dunfordshore	brian_dunfordshore@bridge.com

Back to the top

Features/Limits

Features

The number of ODBC connections is limited only by memory and ODBC itself.
The working limit to the size of a field is 10240 bytes. This can be raised (if needed) to a maximum of 2,147,483,647 bytes. This maximum limit can be raised only by recompiling.
Connections can be opened using a DSN or connection string.
Connections can be opened and closed in any order (but they cannot be closed before they are opened -- maybe next release)

Limits

If the account that the process runs under does not have write permission on the default directory (for the process, not the ODBC DSN) you will probably get a run-time error during an SQLConnection(). I don't think that this is a problem with the code, more like ODBC. This happens because some ODBC drivers need to write a temporary file. I noticed this using the MS Jet Engine (Access Driver).
This has not been optimized for speed nor optimized for memory consumption. This may run into memory bloat.

Back to the top

Installation Instructions

Copy the ODBC.PM file into the \PERL\LIB\WIN32 directory.
Copy the ODBC10x.PLL file into the \PERL\LIB\AUTO\WIN32\ODBC directory. This is either ODBC105.PLL (for versions of Perl 105 or before) or ODBC106.PLL (for versions of Perl 106 or later), renaming the correct file to ODBC.PLL (run "perl -v" to check which version of perl you have).
Define a DSN (Data Source Name) and ensure that you have everything you need to use it normally (ODBC drivers, database files, etc.)
You are now ready to ODBC all over town!

Back to the top

Bug Reports

Please send bug reports to Dave Roth. Include the following (if appropriate):

Versions of both Perl (perl -v) and ODBC
ODBC data source type (Oracle, Access, etc)
Short description of the problem
Small code example which you have tested to ensure that it reproduces the problem as described
Output of the code exmaple

Back to the top

Obtaining the Latest Versions

Win32::ODBC - ftp.roth.net
Perl for Win32 - ftp.hip.com

Back to the top

For More Information on Perl

CPAN - Comprehensive Perl Archive Network - Selected Sites

ftp.metronet.com (Texas)
ftp.cdrom.com (California)
ftp.cis.ufl.edu (Florida)
mango.pinc.com (British Columbia)
ftp.funet.fi (Finland) [Master CPAN site]
ftp.cs.ruu.nl (The Netherlands)
ftp.sunet.se (Sweden)
ftp.demon.co.uk (United Kindom)
coombs.anu.edu.au (Australia)

This page maintined by Joe Casadonte. Please let me if something is wrong or does not make sense. Send these or other comments to: joc@netaxs.com.

Win32::ODBC / 07 May 1996 / joc@netaxs.com

Win32::ODBC Documentation

An updated doc is available

Business Stuff

Copyright

Disclaimer

GNU General Public License

Larry Wall's "Artistic License"

Version History

Features/Limits

Features

Limits

Installation Instructions

Bug Reports

Obtaining the Latest Versions

For More Information on Perl

This site has been hit 7,561,028 times since May 22, 2001

Copyright © 1996 - 2008 Roth Consulting.
Last updated 2004.11.06

	Module Description
	Business Stuff
	Copyright Notice
	Disclaimer
	GNU General Public License
	Larry Wall's "Artistic License"
	Version History
	Author List
	Features/Limits
	Installation Instructions
	Bug Reports
	Latest Versions
	For More Information on Perl

Win32::ODBC Documentation

An updated doc is available

Business Stuff

Copyright

Disclaimer

GNU General Public License

Larry Wall's "Artistic License"

Version History

Features/Limits

Features

Limits

Installation Instructions

Bug Reports

Obtaining the Latest Versions

For More Information on Perl

This site has been hit 7,561,028 times since May 22, 2001

Copyright © 1996 - 2008 Roth Consulting. Last updated 2004.11.06

Copyright © 1996 - 2008 Roth Consulting.
Last updated 2004.11.06