![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461961828.webp)
Connector/ODBC Notes and Tips
1808
Another workaround is to use a
SELECT COUNT(*)
statement for a similar query to get the correct row
count.
To find the number of rows affected by a specific SQL statement in ADO, use the
RecordsAffected
property in the ADO execute method. For more information on the usage of execute method, refer to
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthcnnexecute.asp
.
For information, see
ActiveX Data Objects(ADO) Frequently Asked Questions
.
20.1.7.2.1.7. Using Connector/ODBC with Active Server Pages (ASP)
Select the
Return matching rows
option in the DSN.
For more information about how to access MySQL through ASP using Connector/ODBC, refer to the
following articles:
•
Using MyODBC To Access Your MySQL Database Via ASP
•
ASP and MySQL at DWAM.NT
A Frequently Asked Questions list for ASP can be found at
http://support.microsoft.com/default.aspx?
scid=/Support/ActiveServer/faq/data/adofaq.asp
.
20.1.7.2.1.8. Using Connector/ODBC with Visual Basic (ADO, DAO and RDO) and ASP
Some articles that may help with Visual Basic and ASP:
•
MySQL BLOB columns and Visual Basic 6
by Mike Hillyer (
).
•
How to map Visual basic data type to MySQL types
by Mike Hillyer (
).
20.1.7.2.2. Using Connector/ODBC with Borland Applications
With all Borland applications where the Borland Database Engine (BDE) is used, follow these steps to
improve compatibility:
• Update to BDE 3.2 or newer.
• Enable the
Don't optimize column widths
option in the DSN.
• Enabled the
Return matching rows
option in the DSN.
20.1.7.2.2.1. Using Connector/ODBC with Borland Builder 4
When you start a query, you can use the
Active
property or the
Open
method. Note that
Active
starts by automatically issuing a
SELECT * FROM ...
query. That may not be a good thing if your
tables are large.
20.1.7.2.2.2. Using Connector/ODBC with Delphi
Also, here is some potentially useful Delphi code that sets up both an ODBC entry and a BDE entry for
Connector/ODBC. The BDE entry requires a BDE Alias Editor that is free at a Delphi Super Page near
you. (Thanks to Bryan Brunton
for this):
fReg:= TRegistry.Create;
fReg.OpenKey('\Software\ODBC\ODBC.INI\DocumentsFab', True);
fReg.WriteString('Database', 'Documents');
fReg.WriteString('Description', ' ');
fReg.WriteString('Driver', 'C:\WINNT\System32\myodbc.dll');
fReg.WriteString('Flag', '1');
fReg.WriteString('Password', '');
fReg.WriteString('Port', ' ');
fReg.WriteString('Server', 'xmark');
fReg.WriteString('User', 'winuser');
fReg.OpenKey('\Software\ODBC\ODBC.INI\ODBC Data Sources', True);
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...