Wonger
New Member
I'm developing an app which connects to many different varieties of datasources, primarily via ODBC or OLE DB drivers. I've managed quite well against Sybase, Pervasive, BTRIEVE, Clarion, DBISAM, Advantage, etc. Then I ran into Progress and have been beaten over and over again. I'm hoping someone can clarify some basics for me.
I installed the application whose data I want to access on my PC. The application was developed in Progress 4GL as far as I can tell and the installer also installed the database. A DLC directory and a DB directory exist. The version file says:
PROGRESS Version 9.1D03 as of Wed Dec 4 04:44:43 EST 2002
Inside the DB directory are files with extension:
.b1, .d1, .db, .lg
The application runs on my PC, accessing the database on my PC - there are no other client machines or anything like that.
I downloaded and installed DataDirect 5.1 Progress SQL92 ODBC driver. In the documentation it says that there must be this client software installed: Progress SQL Client Access 9.1D, 9.1E.
QUESTION: Do I really need some special software since I'm accessing this data from the same machine that the database is on?
QUESTOIN: How can I tell if this application's installer installed that software for me?
QUESTION: If it is not installed and it is required, can I install it somehow? I have no contact or access to the original developers.
I was further confused when I tried to set up a DSN using the DataDirect driver. The setup dialog has fields for host name, port number, and database name, as well as data source name, description and user ID.
QUESTIONS: Since the DB is on this machine and distributed with the executable software app, should the host name just be localhost? How do I know the port number...or what's the default? What is the database name? Is it just the name of the .db file?
QUESTION: Alternatively, rather than messing with a DSN, what is the syntax for an ODBC connection string?
Thanks for any help, insight, or suggestions you can give!
I installed the application whose data I want to access on my PC. The application was developed in Progress 4GL as far as I can tell and the installer also installed the database. A DLC directory and a DB directory exist. The version file says:
PROGRESS Version 9.1D03 as of Wed Dec 4 04:44:43 EST 2002
Inside the DB directory are files with extension:
.b1, .d1, .db, .lg
The application runs on my PC, accessing the database on my PC - there are no other client machines or anything like that.
I downloaded and installed DataDirect 5.1 Progress SQL92 ODBC driver. In the documentation it says that there must be this client software installed: Progress SQL Client Access 9.1D, 9.1E.
QUESTION: Do I really need some special software since I'm accessing this data from the same machine that the database is on?
QUESTOIN: How can I tell if this application's installer installed that software for me?
QUESTION: If it is not installed and it is required, can I install it somehow? I have no contact or access to the original developers.
I was further confused when I tried to set up a DSN using the DataDirect driver. The setup dialog has fields for host name, port number, and database name, as well as data source name, description and user ID.
QUESTIONS: Since the DB is on this machine and distributed with the executable software app, should the host name just be localhost? How do I know the port number...or what's the default? What is the database name? Is it just the name of the .db file?
QUESTION: Alternatively, rather than messing with a DSN, what is the syntax for an ODBC connection string?
Thanks for any help, insight, or suggestions you can give!