How configure progress database from server to local and access it/

[Guvera]

Hi friends,

I am having third party API and installed in my server system. In the API they are using progress database and it is maintained in the particular path when we installed it. I want to connect to progress database in server to my local machine. Need to get the all details from the database. Is this possible? Also i tried to connect from ODBC driver. But i couldnt do that. Once i config, i need to connect db and read data from database through MFC application. This part i have a sample. But before, how can we configure. For eg db file path in the server machine : C:\CCure\4GL\.dbf and progress data file etc.,

Thanks

[MarMan]

I've never used a Progress database, but this may help.

[Guvera]

Hi,

Thanks your reply. I put the database file in my local system and give the odbc connection to the db also give the directory File DSN. I create .Net application and in the page load i put the below code.

protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
            string strConn;

            strConn = "DSN=Generaldb;HOST=192.168.2.136;DB=Generaldb.dbf;UID=admin;PWD=admin;PORT=2055;";
            OdbcConnection oConn;

            oConn = new OdbcConnection(strConn);

            oConn.Open();
            }
            catch(Exception ex)
            {
                ex.ToString();
            }

        }

The connection is opened without exception. I dont know what is the table inside the dbf . How can i identify it?

Thanks

[abhijit]

In every database, there is a catalog table, which identifies the tables.
In Oracle you use

SELECT * FROM DBA_TABLES

In SQL Server you execute a stored procedure called sp_tables

I am sure there's something equivalent in Progress that you can query or execute.