Forums

xad388
xad388
Offline
Resolved
0 votes
Is ODBC access built in - if so what port does it use?
I am guessing it would be possible to get at theEmail archives via such a connection.
Saturday, January 30 2010, 07:55 PM
Share this post:
Responses (2)
  • Accepted Answer

    xad388
    xad388
    Offline
    Saturday, February 06 2010, 11:52 AM - #Permalink
    Resolved
    0 votes
    Adding ODBC client will make it easy to do custom apps at the PC with MySQL data on the server.

    As the email search features reveal email as soon as it arrives and pop3 collected email is cleared when email client connects, there must be some other database in which email is deposited on arrival. What is it please and is their an ODBC client for it. I need to write a client ODBC app that parses the server email headers for keywords - matching messages are to be further processed into a order processing system. I'll need access to the message body for the latter.

    Thanks in advance....
    The reply is currently minimized Show
  • Accepted Answer

    Monday, February 01 2010, 08:13 PM - #Permalink
    Resolved
    0 votes
    The MySQL server that comes on ClearOS is pretty standard. ODBC access is available and can be accessed on port 3306.

    Email is NOT stored in MySQL so you cannot access it there.

    You can download an appropriate MyODBC client package from MySQL
    The reply is currently minimized Show
Your Reply