History MSSQL modules
000505
MSSQL::DBlib 1.006 and MSSQL::Sqllib 1.006 released.
News for MSSQL::DBlib
- Compiles and runs with Perl 5.6. Binary for ActivePerl 5.6 available.
- Memory leaks in dbnextrow2
and dbretdata2 fixed.
The one in dbnextrow2 was fairly expensive. Big kudos to Ilya
Chelpanov for pointing out the leaks and providing the fixes. Note:
if you are using old ActiveState Perl 3xx, I'm sorry to tell that the
fix does not apply.
- The module now sets the hostname in the DB-Library login record
from the environment variable COMPUTERNAME. This happens at initiation
time, prior to dblogin,
so you will see the hostname in sp_who et al.
- New and enchanced functions:
dbstrcpy,
dbiscount,
dbgetoff
- DBSETFALLBACK was
not calling it's DB-Library namesake, but the completely wrong routine.
News for MSSQL::Sqllib
- Memory leaks fixed (same as in MSSQL::DBlib, see above).
- The errInfo structure
has a new attribute:
errFileHandle, which permits you to direct error messages to a
file. You should assign the attribute an open file handle. The default
is STDERR.
- Bugfix: sql_sp erroneously
truncated in parameters of the datatypes text and image to 255 in
length. Note that the SP still truncates there parameters value if
the data type is char, varchar, binary or varbinary, since DB-Library
don't handle longer values for these datatypes.
990201
MSSQL::DBlib 1.005 and MSSQL::Sqllib 1.005 released.
General news
- Now supports all known Perl versions from 5.003 and on.
- Added information about SQL Server 7 to the docs.
News for MSSQL::DBlib
- New functions:
dbsqlsend,
dbsqlok,
dbdataready,
dbclrbuf,
dbnextrow2,
reformat_uniqueid and
dbretdata2.
- Changed functions:
- dbrpcsend now has an
optional parameter to specify that dbrpcsend should not wait for
server response. dbrpcsend also provides wee support for the new
SQL Server datatype uniqueidentifier.
- dbnextrow and
dbretdata now have a
parameter to specify that the result should returned as a reference.
- dberrhandle and
dbmsghandle now warns if
you pass name without module qualifications is warnings are activated.
- Deprecated functions in MSSQL::DBlib:
dbnextrow and
dbretdata are now deprecated in
favour of dbnextrow2 and
dbretdata2.
- The DLL is now linked at a non-default base address to improve startup time
somewhat.
- A couple of minor fixes with regards to error checking, uninialized values
and similar.
News for MSSQL::DBlib::Const
- New constant in MSSQL::DBlib::Const::Datatypes: SQLUNIQUEIDENTIFIER.
- Warning about redefinition in MSSQL::DBlib::Const now suppressed.
- Fixed error in export list for MSSQL::DBlib::Const which prevented the
re-export of all MSSQL::DBlib::Const::* modules that ended in "s" -
about half of the modules.
News for MSSQL::Sqllib
- New result style KEYED for
sql and
sql_sp which permits you to
retrieve a result set as a hash keyed by the key columns of the result set.
- The handle attribute errInfo has
several changes:
- You can now specify per message nummer whether it is to be printed.
- By default all informational messages are now printed, save two
login messages. The messages for arthimetic overflow and divizion by
zero are printed with line number, procedure and SQL code. In MSSQL
1.000 these messages was errnoneously suppressed.
- You can now also control
sql_error_handler
with the errInfo attribute.
- The element showplan has been removed, being redundant with other
elements.
- New handle attributes procs and
tables which are used by
sql_sp and
sql_insert respectively
for caching information on stored procedures and tables.
- Using -w, MSSQL::Sqllib 1.000 would generate many warnings about
use of unitialized values. This has been fixed. Also, MSSQL::Sqllib has
more strict definitions how to handle empty result sets with various
result styles.
- The function
sql_unset_conversion was accidently missing from the export list in
MSSQL::Sqllib. This has been fixed.
- sql_set_conversion
was not able to find the default server charset, if the current database
was not master.
- A few more buglet fixes that I don't detail here.
980212
Fix release: the script name was incorrectly analysed at startup,
which could give "Name too long for loginrec field." Hopefully
this solves problems with using MSSQL::* with IIS.
980201
Initial release for ActiveState Perl only.
Last updated 00-05-05 22:44