History MSSQL modules

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