Topic: ODBC under E-Smith

[Nathan]

I've been set the task of finding out if e-smith has the capacity to establish ODBC connections. Does anyone know if it does? If not is there any particular software that we need to install to get it working?

Cheers

[Des Dougan]

E-smith (or Mitel SME) per se doesn't have anything to do with ODBC connections. You need an ODBC client at one end and a SQL database at the other. Mysql ships as part of the distribution and, AFAIK, is an ODBC-compliant datastore.

Des Dougan

[Craig]

You can use myODBC which comes for Win9X/WinNT/2000/XP. It can be downloaded from http://www.mysql.org/downloads/api-myodbc.html. This will allow you to talk to the MySql database on E-Smith via ODBC.

You will also need to setup MyPHP Admin info can be found here http://www.myezserver.com/downloads/mitel/ download dmc-mitel-phpmyadmin-2.2.1-0.noarch.rpm and check out

To install: rpm -ivh dmc-mitel-phpmyadmin-2.2.1-0.noarch.rpm
To configure:
- add-on to administer mySQL
- installed in /opt/administration/phpmyadmin
- edit /opt/administration/phpmyadmin/config.inc.php3 and add the mysql root password
- password may be found by looking at the hidden file /root/.my.cnf
- access via https://yourdomain.com/phpmyadmin using the admin login/password

This site gives you some other ideas on how to configure MyODBC
http://www.myezserver.com/docs/mitel/myodbc-howto.html

Hope this helps.

Craig