History MSSQL modules

010505

News for MSSQL::DBlib

• Added more text functions: dbreadtext, dbmoretext, dbupdatetext, dbprepupdatetext, dbdeletetext and dbcopytext.
• Enhanced text in the manual for dbsetopt and other small documentation fixes.

News for MSSQL::Sqllib

• sql_one now permits more than one result set to be returned, but the total amounts of rows returned must still be exactly one. Since SQL Server may return an empty result even for a SET statement, it is a bit embarrassing that it didn't work this way from the beginning...
• The $rowstyle and $resultstyle parameters of sql and sql_sp can now be specified in any order.
• There was a bug in sql and sql_sp which caused the script to crash when there was no results sets at all, for instance because there was a compilation error in the SQL code, and you had set the maxSeverity in errInfo to 25 to prevent any stop on SQL errors, and you had specified a list or a hash to receive the return value.
      This is now fixed, and sql and sql_sp are now specified in this situation to return undef if you receive the return value in a scalar and an empty list/hash in the other cases.
• Fixed problem that prevented sql_init to succeed on early service packs of SQL6.5.
• The test script 3_conversion.t now also works if your OEM charset is CP437.

Known issues

000914

News for MSSQL::DBlib

• No actual changes in program code.
• Minor documentation updates for SQL 2000.

News for MSSQL::Sqllib

• New handle attribute SQL_version, gives you the SQL Server version.
• Message 3622, A domain error occurred is now in alwaysPrint by default.
• Minor adaptions to resolve things that broke with SQL 2000.

000505

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

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

980201