Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

ODBC DB Connection

Discussion in '3CX Phone System - General' started by megatech, Nov 11, 2009.

Thread Status:
Not open for further replies.
  1. megatech

    Joined:
    Oct 19, 2009
    Messages:
    14
    Likes Received:
    0
    Hi
    I want to access the Progress DB and run some direct queries. Can anyone tell what the connection setup needs to be.
    The odbc screen has these fields

    Data Source:
    DataBase:
    Server:
    User Name:
    Password:
    SSL Mode:
    Port: 5432

    thanks
    peter
     
  2. danj

    Joined:
    Oct 26, 2007
    Messages:
    16
    Likes Received:
    0
    Hello,

    The following settings should get you logged in.

    Name: 3CX
    Host: 127.0.0.1
    Port: 5480
    Maintenance DB: phonesystem
    Username: [phonesystem]
    Password: [RANDOM PASSWORD] - look in 3CXPhoneSystem.ini - dbPassword string

    Regards,

    Dan Jennings
    ___________
    Deerfield.com
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. ice

    ice New Member

    Joined:
    Jun 11, 2008
    Messages:
    108
    Likes Received:
    0
    Is it works for v8?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. megatech

    Joined:
    Oct 19, 2009
    Messages:
    14
    Likes Received:
    0
    thanks worked great - we would have lost this account if we couldn'd pull data from the db
    thanks
     
  5. KerryG

    KerryG Active Member

    Joined:
    Jun 19, 2009
    Messages:
    960
    Likes Received:
    0
    just out of curiosity, what are you doing with the data and why was it so important? This is interesting to know the reasons behind a situation like this.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Thread Status:
Not open for further replies.