# Access to API helpers through ODBC

**URL:** <https://forum.sambapos.com/t/access-to-api-helpers-through-odbc/17258>\
**Category:** V5 Question\
**Created:** [March 30, 2018, 1:34am UTC](https://forum.sambapos.com/t/access-to-api-helpers-through-odbc/17258 "2018-03-30T01:34:59Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\
**Post date:** [April 2, 2018, 1:11am UTC](https://forum.sambapos.com/t/access-to-api-helpers-through-odbc/17258/10 "2018-04-02T01:11:21Z")

</div>

> [@pauln](#):
>
> If I eventually get ODBC working I will drop a post back here.

The following isn’t using `host.X()` API helpers (they did not exist when this was written); instead it is using ActiveX, and it works. If I was to attempt this again, I would definitely try `host.X()` instead …

> [@Query MySQL from within Samba](https://forum.sambapos.com/t/query-mysql-from-within-samba/9379/3):
>
> This works for MS SQL using either of the first listed drivers, so if you have a valid ODBC driver installed for MySQL, then something like this should theoretically work: function myConnect() { var driver = ""; driver = "ODBC Driver 11 for SQL Server"; driver = "SQL Server Native Client 11.0"; //driver = "mySQL ODBC 3.51 Driver"; var conString = "Driver={"+driver+"};"; conString += "Server=127.0.0.1;"; //conString += "Port=4900;"; conString += "Database=SambaPOS5;"; conStrin…

---

_[View the full topic](https://forum.sambapos.com/t/access-to-api-helpers-through-odbc/17258)._
