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.