summaryrefslogtreecommitdiff
path: root/databases/myodbc
AgeCommit message (Collapse)AuthorFilesLines
2011-11-01Recursive bump for graphics/freetype2 buildlink addition.sbd1-1/+2
2011-08-19Changes 5.1.8:adam6-30/+30
* Documentation in .CHM and .HLP format has been removed from the distribution. * For some procedure and parameter combinations SQLProcedureColumns() did not work correctly. For example, it could not return records for an existing procedure with correct parameters supplied. * Further, it returned incorrect data for column 7, TYPE_NAME. For example, it returned VARCHAR(20) instead of VARCHAR. * The MySQL Connector/ODBC MSI installer did not set the InstallLocation value in the Microsoft Windows registry. * In bulk upload mode, SQLExecute would return SQL_SUCCESS, even when the uploaded data contained errors, such as primary key duplication, and foreign key violation. * SQLDescribeCol and SQLColAttribute could not be called before SQLExecute, if the query was parameterized and not all parameters were bound. * Note, MSDN states that “For performance reasons, an application should not call SQLColAttribute/SQLDescribeCol before executing a statement.” However, it should still be possible to do so if performance reasons are not paramount. * When SQLNumResultCols() was called between SQLPrepare() and SQLExecute() the driver ran SET @@sql_select_limit=1, which limited the resultset to just one row. * After installing MySQL Connector/ODBC, the system DSN created could not be configured or deleted. An error dialog was displayed, showing the error message “Invalid attribute string”. * In this case the problem was due to the fact that the driver could not parse the NULL-separated connection string. * When used after a call to SQLTables(), SQLRowCount() did not return the correct value.
2011-01-13png shlib name changed for png>=1.5.0, so bump PKGREVISIONs.wiz1-2/+2
2010-09-30Bump PKGREVISION by default mysql version changed from 5.0 to 5.1.obache1-1/+2
2010-05-03Update to MYSQL Connector/ODBC 5.1.6 so this will actually workjnemeth7-12/+66
with a modern version of MySQL. Also, fix some DESTDIR issues. 5.1.6 Functionality added or changed: * Providing an empty string as the catalog argument to SQLTables() will return an empty result set. A catalog must have a name. * Remove use of "old" SQLLEN/SQLULEN types aliases. They are not supported in unixODBC 2.2.13 and later 64-bit builds. Removed SQLROWCOUNT, SQLROWSETSIZE, SQLTRANSID, SQLROWOFFSET. * Connection parameters can be specified individually instead of using OPTIONS bitflags. (See connection parameters documentation) * Edit controls for INITSTMT and CHARSET DSN options are added to the native Windows GUI. (Bug #40932) * Length/Indicator pointer is now stored and used internally as pointer to SQLLEN and not to SQLINTEGER. Using SQLINTEGER pointers as StrLen_or_IndPtr parameter of SQLBindParameter/SQLBindCol may cause crash on 64bit platforms. * Query log is not overwritten, but appended instead. (Bug #44965) * Fixed tab order in Windows datasource config dialog. (Bug #42905) Bugs fixed: * Add support for data-at-execution with positioned insert/update (Bug #37649) * Output string length from SQLDriverConnect() includes NULL-term (Bug #38949) * SQLGetInfo() returns 0 for SQL_CATALOG_USAGE info (Bug #39560) * SQLDriverConnect() may truncate output string erroneously (Bug #37278) * SQLTables() doesn't properly handle empty strings to list catalogs and tables. (Bug #39561) * Calling SQLDriverConnect() with no output buffer will crash if not prompting. (Bug #40316) * SQLTables() doesn't return the catalog name if the table is given and the catalog argument is NULL. (Bug #39957) * Driver crashes when attempting to retrieve data in a character set not compiled into libmysql. (Bug #39831) * SQLGetTypeInfo() doesn't return any rows SQL_TIMESTAMP on an ODBC v2 connection. (Bug #30626) * Positioned update with SQL_C_NUMERIC loses prec/scale values (Bug #39961) * ADO adUseServer cursor is lost after updating adLongVarWChar field (Bug #26950) * Calling SQLDescribeCol() with a NULL buffer and non-zero buffer length causes a crash. (Bug #41942) * NULL parameters don't work correctly with ADO. (Bug #41256) * Unable to retrieve null DECIMAL fields in ADO. (Bug #41081) * Fix positioned update using data-at-execution, bind offsets and row-wise binding. (Bug #36071) * SQLConfigDataSource may fail with: Cannot find driver (Bug #41796) * FLAG_NO_BIGINT still returns bigint for SQLDescribeCol() (Bug #17679) * Random access violation exceptions (0xC0000005) in ASP scripts in the SQLSetConnectAttrW. (Bug #44971) * Binding SQL_C_BIT to an integer column didn't work. (Bug #39644) * Inserting a new record using SQLSetPos if the table is from different than current catalog. (Bug #41946) Includes changes from Connector/ODBC 3.51.27. Built using MySQL 5.1.34sp1. ---- 5.1.5 (18-Aug-2008) Functionality added or changed: * Added FLAG_NO_BINARY_RESULT connection option to always handle binary function results as character data. (Bug #29402) Bugs fixed: * Some catalog functions used fixed-sized buffers for handling arguments that could be overrun, and misinterpreted some arguments as patterns when they should be treated as identifiers. (Bug #36275) * SQLDriverConnect() returned SQL_ERROR when the user cancelled the dialog box instead of SQL_NO_DATA. (Bug #36293) * System DSN lookup (using ODBC_BOTH_DSN) fails on Windows XP. (Bug #36203) * SQLProcedures() followed by SQLFreeStmt() crashes (Bug #36069) * ADO adUseServer cursor is lost after updating adLongVarWChar field (Bug #26950) * SQL_TYPE_TIMESTAMP and SQL_TYPE_TIME parameters were incorrectly included when parameters were expanded. (Bug #37342) * DSN-less connection prompting cannot lookup driver entry (Bug #37254) Includes changes from Connector/ODBC 3.51.26. Built using MySQL 5.0.60sp1. ---- 5.1.4 (15-Apr-2008) Bugs fixed: * SQLGetDiagRec() sometimes returned SQL_SUCCESS but no error message. (Bug #33910) * Driver installer (myodbc-installer.exe) fails to create a new DSN (Bug #35776) * Get wrong result with decimal(8,2) field type (Bug #35920) Includes changes from Connector/ODBC 3.51.25. Built using MySQL 5.0.56sp1. ---- 5.1.3 (26-Mar-2008) Functionality added or changed: * Added SSLVERIFY connection option to verify server certificate. By default certificate is not verified now. (Bug #34648) * Database list height is autoadjusted in Windows GUI. (Bug #33918) Bugs fixed: * Recordset-based update fails if blob field is queried. (Bug #19065) * Descriptor records were not cleared correctly when calling SQLFreeStmt(SQL_UNBIND). (Bug #34271) * The driver incorrectly reported that the SQL standard CAST() and CONVERT() functions were supported. (Bug #33808) * Unresolved symbols "min" and "max" in libmyodbc3.so w/gcc 4.2. (Bug #34256) * Notorious #DELETED problem when linking tables in Access and BIGINT PK (Bug #24535) * MyODBC 51/Access unable to use DBEngine.RegisterDatabase to create a DSN (Bug #33825) * Unable to use surrogate pairs into with unicode column. (Bug #34672) * SQLGetData w/SQL_C_WCHAR gives incorrect data. (Bug #34429) Includes changes from Connector/ODBC 3.51.24. Built using MySQL 5.0.52. ---- 5.1.2 (12-Feb-2008) Functionality added or changed: * SQLForeignKeys uses INFORMATION_SCHEMA when it is available on the server, which allows more complete information to be returned. * Disabled MYSQL_OPT_SSL_VERIFY_SERVER_CERT when using an SSL connection. * Explicit descriptors are implemented. (Bug #32064) * Changed SQL_ATTR_PARAMSET_SIZE to return an error until support for it is implemented. Bugs fixed: * Tried to use the already-entered database when connecting to get list of databases in Windows setup library. (Bug #33615) * SQLForeignKeys returned an empty string for the schema columns instead of a NULL. (Bug #19923) * SQLGetInfo() reported characters for SQL_SPECIAL_CHARACTERS that were not encoded correctly. (Bug #33130) * Adding or updating a row using SQLSetPos() on a result set with aliased columns would fail. (Bug #6157) * Changing the DSN name when editing a DSN left behind the DSN under the old name in addition to creating the new entry. Fixed for native Windows GUI. (Bug #31165, fixed for Qt GUI in 3.51.23) * Numeric values (such as OPTIONS or PORT) were not read correctly from a connection string if they were not the last parameter. (Bug #33822) * The SSLCIPHER option was saved incorrectly on Windows. (Bug #33897) * The cursor position was incorrect after rows were deleted from a static cursor. (Bug #33388) * Dynamic cursors on statements with parameters were not supported. (Bug #11846) * FLAG_COLUMN_SIZE_S32 did not limit the octet length or display size reported for fields, causing problems with Microsoft Visual FoxPro. (Bug #30890) * Retrieving SQL_C_WCHAR data with SQLGetData() could crash due to incorrect handling of the buffer length. (Bug #32684) Includes changes from Connector/ODBC 3.51.23. Built using MySQL 5.0.52. ---- 5.1.1 (12-Dec-2007) Functionality added or changed: * Added MSI installer for Windows 64-bit (Bug #31510) * Implemented support for SQLCancel(). (Bug #15601) * Added wrappers for missing ODBC driver manager installer functions. This makes it possible to use the driver with unixODBC 2.2.11, which is the version shipped with Debian and Ubuntu. (Bug #32685) * Disallow 'SET NAMES' in initial statement and in executed statements. * Replaced the internal library which handles creation and loading of DSN information. The new library, which was originally a part of Connector/ODBC 5.0, supports Unicode option values. * Implemented native Windows setup library * Removed monitor (myodbc3m) and dsn-editor (myodbc3c). * Replaced myodbc3i (now myodbc-installer) with Connector/ODBC 5.0 version. * Added support for SQL_NUMERIC_STRUCT (Bug #3028, #24920). * Removed non-threadsafe configuration of the driver. The driver is now always built against the threadsafe version of libmysql. Bugs fixed: * SQL statements were limited to 64k. (Bug #30983) * Diagnostics were not correctly cleared on connection and environment handles. * SQLCopyDesc() did not correctly copy all records. * Freeing a statement resulted in a memory leak due to descriptor records not being freed.. (Bug #31115) * SQL_ODBC_SQL_CONFORMANCE was not handled by SQLGetInfo(). * NULL pointers passed to SQLGetInfo() could result in a crash. * Passwords with ';' were not handled correctly. (Bug #16178) * Binding of columns between calling prepare and execute caused premature statement execution. (Bug #29239) * ADO could not open a recordset that has a DECIMAL field (Bug #31720) * SQLError() incorrectly cleared the error information, making it unavailable from subsequent calls to SQLGetDiagRec(). * ADO was unable to open record set using dynamic cursor. (Bug #32014) * SQLSetConnectAttr() did not clear previous errors, possibly confusing SQLError(). * SQLDescribeColW returned UTF-8 column as SQL_VARCHAR instead of SQL_WVARCHAR. (Bug #32161) * Fixed SQL_ATTR_PARAM_BIND_OFFSET, and fixed row offsets to work with updatable cursors. * SQLSetPos w/SQL_DELETE advances dynamic cursor incorrectly. (Bug #29765) * Recordset Update() fails in 5.1 ODBC connector when using adUseClient cursor. (Bug #26985) * MyODBC 5/ ADO Not possible to update a client side cursor. (Bug #27961) * Intermixing of SQLGetData() using SQL_C_CHAR and SQL_C_WCHAR on the same field value was incorrect. (Bug #28617) * SQLNativeSql() didn't properly handle the output length pointer. (Bug #10128 & Bug #31049) Includes changes from Connector/ODBC 3.51.21 and 3.51.22. Built using MySQL 5.0.52. ---- 5.1.0 (8-Sep-2007) Functionality added or changed: * Added support for SQL_C_WCHAR. * Added support for Unicode functions (SQLConnectW, etc). * Added descriptor support (SQLGetDescField, SQLGetDescRec, etc) ---- 3.51.27 (20-Nov-2008) Bugs fixed: * Cannot use ssl (Bug #29955) * Enable auto reconnect doesn't work (Bug #37179) * Add read and write timeouts on the connection (Bug #40407) ---- 3.51.26 (7-Jul-2008) Bugs fixed: * Access Violation in myodbc3.dll (Bug #30770) * Truncation of "SHOW CREATE TABLE" result (Bug #24131) * Added a new connection option FLAG_NO_BINARY_RESULT. Fixed field type charset 63 problem. (Bug #29402)
2010-01-29DESTDIR supportjoerg1-1/+3
2009-12-15Recursive bump for libltdljoerg1-2/+2
2009-08-26bump revision because of graphics/jpeg updatesno1-1/+2
2009-06-14Remove @dirrm entries from PLISTsjoerg1-2/+1
2008-11-11Update to mysql-connector-odbc-3.51.26r1127 (from 3.51.12). Mostbouyer5-56/+17
important change: 3.51.12 doesn't work anymore with mysql-client-5.0.67nb1, a function has been removed from the mysql-client library. Other changes: * lots of bug fixes * Added FLAG_COLUMN_SIZE_S32 to limit the reported column size to a signed 32-bit integer. This option is automatically enabled for ADO applications, in order to work around a bug in ADO. (Bug #13776) * Added FLAG_MULTI_STATEMENTS to allow issuing queries that contain multiple statements. Also added to the setup GUI. (Bug #7445) * Removed support for the TRACE and TRACEFILE DSN options. The standard ODBC logging should be used. * Added support for SQL_ATTR_ROW_BIND_OFFSET_PTR in normal cursors. (Bug #6741) * Added SSL options to the GUI setup dialog. * Added an option (CHARSET) for specifying the default character set for a connection. This must be used instead of a "SET NAMES" statement. Also available from the GUI setup dialog. (Related to Bug #6667 and Bug #9498.) * Dis-allow NULL ptr for null indicator when calling SQLGetData() if value is null. Now returns SQL_ERROR w/state 22002. * Fixed calling convention ptr and wrong free in myodbc3i, and fixed the null terminating (was only one, not two) when writing DSN to string. * Added support for using SSL. This is not yet exposed in the setup GUI, but must be enabled through configuration files or the DSN. (Bug #12918) * Added auto-reconnect option because automatic reconnect is now disabled by default in libmysql * Added auto is null option (Bug #10910) * Added support for SQLMoreResults * Checking SQL_ATTR_CONNECTION_DEAD now always calls mysql_ping() to check for a dead connection. * Remove ODBC escape syntax { and } that begin and terminate statements, allowing {CALL (?)} for procedures that don't require OUT or INOUT parameters * Improved regression tests * Added --with-separate-debug-driver ./configure option
2008-04-12Convert to use PLIST_VARS instead of manually passing "@comment "jlam2-5/+6
through PLIST_SUBST to the plist module.
2007-01-14*BSD dosen't have strndup.obache3-3/+19
Pointed out by Yasushi Oshima in PR 33160. Bump PKGREVISION.
2007-01-14Fix CONFIGURE option to pick up iODBC driver (default option) correctly.obache2-4/+4
Pointed out by Yasushi Oshima in PR 33147. Bump PKGREVISION.
2006-07-22Added "c" to USE_LANGUAGES for packages that use GNU configure scripts,rillig1-2/+2
since they always need a C compiler, even when the source code is completely in C++. For some other packages, stated in the comment that a C compiler is really not needed.
2006-03-04Point MAINTAINER to pkgsrc-users@NetBSD.org in the case where nojlam1-2/+2
developer is officially maintaining the package. The rationale for changing this from "tech-pkg" to "pkgsrc-users" is that it implies that any user can try to maintain the package (by submitting patches to the mailing list). Since the folks most likely to care about the package are the folks that want to use it or are already using it, this would leverage the energy of users who aren't developers.
2006-02-05Recursive revision bump / recommended bump for gettext ABI change.joerg1-1/+2
2006-01-23Update to 3.51.12 (latest stable version).xtraeme5-32/+90
There were zillions of changes... please see the Changelog file. Now it builds with both mysql-4.1.x and mysql-5.1.x. pkgsrc changes: Supported build options: * myodbc-gui: builds the QT widgets library. (disabled) * myodbc-iodbc: uses iodbc for the odbc functions. (enabled) * myodbc-unixodbc: uses unixodbc for the odbc functions. (disabled) Uses MASTER_SITE_MYSQL.
2006-01-08Bump PKGREVISION due to mysql.buildlink3.mk changes (default mysqlxtraeme1-2/+2
pkg has been changed to 5.x). Reminded by wiz... thanks.
2006-01-07databases/mysql-client does not exist anymore. Provide a replacement usingrillig1-2/+2
mk/mysql.buildlink3.mk.
2005-09-17Buildlink mysql-client and iodbc, instead of using DEPENDS.minskim1-8/+8
2005-05-22Remove USE_GNU_TOOLS and replace with the correct USE_TOOLS definitions:jlam1-2/+2
USE_GNU_TOOLS -> USE_TOOLS awk -> gawk m4 -> gm4 make -> gmake sed -> gsed yacc -> bison
2005-02-23Add RMD160 digests in addition to SHA1 ones.agc1-1/+2
2004-10-03Libtool fix for PR pkg/26633, and other issues. Update libtool to 1.5.10tv1-1/+2
in the process. (More information on tech-pkg.) Bump PKGREVISION and BUILDLINK_DEPENDS of all packages using libtool and installing .la files. Bump PKGREVISION (only) of all packages depending directly on the above via a buildlink3 include.
2004-09-22Mechanical changes to package PLISTs to make use of LIBTOOLIZE_PLIST.jlam1-4/+1
All library names listed by *.la files no longer need to be listed in the PLIST, e.g., instead of: lib/libfoo.a lib/libfoo.la lib/libfoo.so lib/libfoo.so.0 lib/libfoo.so.0.1 one simply needs: lib/libfoo.la and bsd.pkg.mk will automatically ensure that the additional library names are listed in the installed package +CONTENTS file. Also make LIBTOOLIZE_PLIST default to "yes".
2004-01-22replace deprecated USE_GMAKE with USE_GNU_TOOLS+=make.grant1-2/+2
2003-07-17s/netbsd.org/NetBSD.org/grant1-2/+2
2003-06-02Use tech-pkg@ in favor of packages@ as MAINTAINER for orphaned packages.jschauma1-2/+2
Should anybody feel like they could be the maintainer for any of thewe packages, please adjust.
2001-11-01Move pkg/ files into package's toplevel directoryzuntum2-1/+1
2001-09-27Mechanical changes to 375 files to change dependency patterns of the formjlam1-2/+2
foo-* to foo-[0-9]*. This is to cause the dependencies to match only the packages whose base package name is "foo", and not those named "foo-bar". A concrete example is p5-Net-* matching p5-Net-DNS as well as p5-Net. Also change dependency examples in Packages.txt to reflect this.
2001-04-18Move to sha1 digests, and add distfile sizes.agc1-1/+2
2001-04-17+ move the distfile digest/checksum value from files/md5 to distinfoagc1-1/+1
+ move the patch digest/checksum values from files/patch-sum to distinfo + include distfile filesizes in distinfo
2001-04-15fix fatal typo - INSTALhubertf1-4/+4
2001-04-06Install some documentation.hubertf2-2/+10
2001-04-04Initial import of myodbc, an ODBC driver for mysql, into the packagesagc4-0/+37
collection.