History MSSQL modules

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