[prev in list] [next in list] [prev in thread] [next in thread]
List: mysql-odbc
Subject: bk commit - MyODBC 3.51
From: "venu () mysql ! com" <venu () mysql ! com>
Date: 2002-09-14 21:27:15
[Download RAW message or body]
Below is the list of changes that have just been commited into a local
MyODBC 3.51 repository of 'venu'. When 'venu' does a push, they will
be propogaged to the main repository and within 24 hours after the push
into the public repository.
For more information on how to access the public repository see
http://www.mysql.com/products/myodbc/faq.html#Development_source
ChangeSet
1.216 02/09/14 13:02:56 venu@myvenu.com +4 -0
configure.in:
3.51.04 release changes
Docs/Support/test-make-manual
1.3 02/09/14 13:02:45 venu@myvenu.com +1 -1
Docs/Support/test-make-faq
1.4 02/09/14 13:02:38 venu@myvenu.com +1 -1
Docs/faq.texi
1.37 02/09/14 13:02:31 venu@myvenu.com +51 -7
configure.in
1.11 02/09/14 13:02:09 venu@myvenu.com +1 -1
3.51.04 release changes
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: venu
# Host: myvenu.com
# Root: /home/venu/work/odbc/dev-3.51
--- 1.3/Docs/Support/test-make-faq Sat Feb 2 13:16:17 2002
+++ 1.4/Docs/Support/test-make-faq Sat Sep 14 13:02:38 2002
@@ -36,7 +36,7 @@
faq.aux faq.cp faq.cps faq.dvi \
faq.fn faq.fns faq.ky faq.html \
faq.pg faq.toc faq.tp faq.vr \
- faq.info faq_toc.html ;
+ faq.info faq_toc.html faq.log;
do
rm -f $file
done
--- 1.2/Docs/Support/test-make-manual Sat Feb 2 13:16:18 2002
+++ 1.3/Docs/Support/test-make-manual Sat Sep 14 13:02:45 2002
@@ -36,7 +36,7 @@
manual.aux manual.cp manual.cps manual.dvi \
manual.fn manual.fns manual.ky manual.html \
manual.pg manual.toc manual.tp manual.vr \
- manual.info manual_toc.html ;
+ manual.info manual_toc.html manual.log ;
do
rm -f $file
done
--- 1.10/configure.in Thu May 30 17:22:40 2002
+++ 1.11/configure.in Sat Sep 14 13:02:09 2002
@@ -1,6 +1,6 @@
AC_INIT(myodbc3.c)
-AM_INIT_AUTOMAKE(myodbc, 3.51.03)
+AM_INIT_AUTOMAKE(myodbc, 3.51.04)
myodbc_version=$VERSION
--- 1.36/Docs/faq.texi Wed May 29 21:00:49 2002
+++ 1.37/Docs/faq.texi Sat Sep 14 13:02:31 2002
@@ -738,6 +738,11 @@
$ lnn -s libmyodbc3-3.51.01.so libmyodbc3.so
@end example
+@strong{NOTE:} For more information about how to build and setup the
+static and shared libraries across the different platforms refer to '
+@uref{http://www.fortran-2000.com/ArnaudRecipes/sharedlib.html,
+Using static and shared libraries across platform}'.
+
@node Development source, , Unix source, Installation Related
@section How do I install the driver from development source tree ?
@@ -1577,6 +1582,7 @@
* COUNT(*) with MyODBC :: While executing the query with COUNT
(*), "SELECT count (*) FROM table .." using MyODBC (3.51), it returns an
error. What is the reason ?
* AppendChunk() and GetChunk():: Whenever I use AppendChunk() or
GetChunk() methods of ADO, I get an error 'Multiple-step operation
generated errors. Check each status value'. What is the reason ?
* Total number of rows:: How to I find total number of rows
affected by a particular SQL statement in ADO ?
+* Blob-Article::
* SAMPLE - VB:: SAMPLE - VB with ADO and DAO
* ASP with MyODBC:: ASP and MySQL with MyODBC
* ADO:: INFO : Frequently Asked Questions on
ActiveX Data Objects (ADO)
@@ -1605,7 +1611,7 @@
A simple example can be found from,
@uref{http://www.dwam.net/iishelp/ado/docs/adomth02_4.htm}
-@node Total number of rows, SAMPLE - VB, AppendChunk() and GetChunk(),
VB Related
+@node Total number of rows, Blob-Article, AppendChunk() and GetChunk(),
VB Related
@section How do I find total number of rows affected by a particular
SQL statement in ADO ?
@@ -1614,7 +1620,16 @@
@uref{http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthcnnexecute.asp}.
-@node SAMPLE - VB, ASP with MyODBC, Total number of rows, VB Related
+
+@node Blob-Article, SAMPLE - VB, Total number of rows, VB Related
+@section How do I insert/fetch the blob columns data from VB ?
+
+Here is a good article from @code{Mike Hillyer}; which explains
+about how to insert and/or fetch data from blob columns through MyODBC
from ADO:
+@uref{http://www.dynamergy.com/mike/articles/blobaccessvb.html}.
+
+
+@node SAMPLE - VB, ASP with MyODBC, Blob-Article, VB Related
@section SAMPLE - VB with ADO, DAO and RDO
A simple examples for the usage of ADO, DAO and RDO with VB can be
found from:
@@ -1728,12 +1743,14 @@
@menu
* Dynamic Cursor:: Does MyODBC 3.51 support Dynamic Cursor
Type ?
+* Transaction:: Transactions are not enabled
+* NoCuror:: No cursor name found
* MyODBC Compatibility:: Can I still use my MyODBC applications
with MyODBC 3.51 ?
-* MyODBC-Net::
+* MyODBC-Net:: MySQL .NET interfaces
* Tested Applications:: INFO : Tested applications with MyODBC
@end menu
-@node Dynamic Cursor, MyODBC Compatibility, General Functionality,
General Functionality
+@node Dynamic Cursor, Transaction, General Functionality, General
Functionality
@section Does MyODBC 3.51 support Dynamic Cursor Type ?
Yes. MyODBC 3.51 supports @code{@strong{Dynamic cursor}} type along
with
@@ -1745,7 +1762,28 @@
Cursor'}} option from the DSN configuration.
-@node MyODBC Compatibility, MyODBC-Net, Dynamic Cursor, General
Functionality
+@node Transaction, NoCuror, Dynamic Cursor, General Functionality
+@section Why do I get an error '@code{Transactions are not enabled}' ?
+
+When the application issues any transactional call, and if the
underlying
+MySQLserver doesn't support transactions or if they are not enabled,
then
+the driver returns this error. To overcum from this, one must use
MySQL-max
+version with table types as either BDB/InnoDB.
+
+Also, if your server supports transactional table types InnoDB/BDB,
then
+make sure the 'disable transactions' option is not set from the DSN
+configuration.
+
+
+@node NoCuror, MyODBC Compatibility, Transaction, General Functionality
+@section Why do I get '@code{Cursor not found}' error ?
+
+This is becuase the application is using old MyODBC 2.50 version, and
+it did not set the cursor name explicitly through SQLSetCursorName. The
fix
+is to upgrade to MyODBC 3.51 version.
+
+
+@node MyODBC Compatibility, MyODBC-Net, NoCuror, General Functionality
@section Can I still use MyODBC 2.50 applications with MyODBC 3.51 ?
Yes. If you find something is not working with MyODBC 3.51 that works
with
@@ -1757,12 +1795,16 @@
Yes. It has been tested with the following Microsoft .NET Providers:
@itemize
@item
-ODBC.NET(@uref{http://www.mysql.com/products/myodbc/manual.html#MyODBC_With_.NET, Demo sample}),
+ODBC.Net(@uref{http://www.mysql.com/products/myodbc/manual.html#MyODBC_With_.NET, Demo sample}),
@end itemize
+Here is a article
"@uref{http://www.mysql.com/newsletter/2002-07/a0000000035.html,
+Exploring MySQL on .NET environment}"; which covers about all MySQL
.Net interfaces
+along with some useful examples.
@strong{Caution}: Using ODBC.NET with MyODBC, while fetching empty
string
(0 length), it starts giving the SQL_NO_DATA exception. You can get the
-patch for this from
@uref{http://support.microsoft.com/default.aspx?scid=kb;EN-US;q319243}
+patch for this from
@uref{http://support.microsoft.com/default.aspx?scid=kb;EN-US;q319243}.
+
@node Tested Applications, , MyODBC-Net, General Functionality
@@ -1830,6 +1872,8 @@
Open Office (@uref{http://www.openoffice.org})
@item
Star Office
(@uref{http://wwws.sun.com/software/star/staroffice/6.0/index.html})
+@item
+G2-ODBC bridge (@uref{http://www.gensym.com})
@end itemize
If you know of any other applications that work with @code{MyODBC},
please send a mail to @email{myodbc@@lists.mysql.com} about this!
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread6075@lists.mysql.com
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic