ODBC Connection

[kamlesh patel]

Dear Sir,

ODBC Connection is slower then native connection.

Which connection is best: ODBC or Adodb.

Regards

Kamlesh

[Grigory Filatov]

Dear Kamlesh,

The choice between ODBC (Open Database Connectivity) and ADOdb (ActiveX Data Objects Database) depends on several factors, including your specific use case, performance requirements, and the environment in which you are working. Here are some considerations to help you decide:

ODBC
1. Compatibility: ODBC is a widely supported standard and can connect to a variety of databases, making it a good choice if you need to work with multiple database systems.
2. Performance: While ODBC can be slower than native connections, it is generally reliable and well-optimized for many types of database operations.
3. Flexibility: ODBC drivers are available for many different databases, which can be useful if you need to switch between different database systems.

ADOdb
1. Performance: ADOdb is often faster than ODBC because it is designed to work more closely with the underlying database system. It can leverage native database drivers, which can result in better performance.
2. Ease of Use: ADOdb provides a more object-oriented interface, which can make it easier to work with, especially if you are already familiar with object-oriented programming.
3. Integration: ADOdb is well-integrated with Microsoft technologies, making it a good choice if you are working within a Microsoft-centric environment.

Which One to Choose?
- Use ODBC if you need broad compatibility with different database systems and are willing to trade off some performance for flexibility.
- Use ADOdb if you are working within a Microsoft environment and need better performance and a more object-oriented interface.

Ultimately, the best choice depends on your specific requirements and the environment in which you are working. If performance is a critical factor and you are working with a database that has good ADOdb support, ADOdb might be the better choice. If you need to work with multiple database systems and require broad compatibility, ODBC might be more suitable.

HTH,
Grigory

среда, 28 мая 2025 г. в 10:32:00 UTC+2, patel.h...@gmail.com:

[Ivanil Marcelino]

Good morning, 

Just an addendum:

I use ADO extensively with multiple databases simultaneously: SQL Server, Oracle, DBF, Access, Excel – and I could also include MySQL, Firebird, and MariaDB on the list, as I know other colleagues use them as well.

Perhaps it would be more accurate to say: if you are going to develop your app on Linux, then opt for ODBC; but if it's on Windows, use ADO.

Please note that I'm referring to your application – the database server's operating system doesn't matter.

Regards,
Ivanil

--
Visit our website on https://www.hmgextended.com/ or https://www.hmgextended.org/
---
You received this message because you are subscribed to the Google Groups "Harbour Minigui" group.
To unsubscribe from this group and stop receiving emails from it, send an email to minigui-foru...@googlegroups.com.
To view this discussion, visit https://groups.google.com/d/msgid/minigui-forum/CAPFyMQPLFFQzYU5sK5Zv53znFYZHyGhNfZqFHqU2MM5f_PsqQA%40mail.gmail.com.

[kamlesh patel]

Sir,

Thank you for the information. 

Please share an ADO example.

Regards

Kamlesh

[Assistenza PcModula]

Il 29/05/2025 06:51, kamlesh patel he wrote:

Sir,

Thank you for the information. 

Please share an ADO example.

Regards

Kamlesh

Hi Kamlesh,
thanks for your request.
I use this dos command: findstr /s /m /i /c:adodb c:\minigui\samples\*.prg
and i obtain all demos that contain the word Adodb.
As you can verify there are at least 6 demos that can be
help.

Happy coding. 🙂

--
Pierpaolo Martinello [ Minigui Team ]
IW1CUY Ham Radio From Biella Italy
Linux User 177880