i have the same problem
I've the Merant Progress ODBC driver (DataDirect Connect ODBC
3.60).
I'm running Progress V8.3C on Windows NT Workstation 4.
Apache web Server.
I've managed to set-up the driver correctly to access a database on the
server , when I do a test connect, I get a message saying that a connection
has been established.
I've also set up OID/OIB as per the Progress ODBC FAQ (i.e. set up my
environment variables, started the OIB service etc).
I am using PHP's ODBC functions to access the database through a Web
browser, my code is as follows:
//create connecyion
$connection = odbc_connect("allin1", "", "")
or die("Couldn't connect to database allin1);
// Create SQL statement
$sql = "SELECT * from COMPANY";
$sql_result = odbc_prepare($connection, $sql)
or die("Couldn't prepare query");
odbc_execute($sql_result)
or die("Couldn't execute query");
odbc_result_all($sql_result, "border=1");
odbc_free_result($sql_result);
odbc_close($connection);
?>
When I access this page, I get the following message:
Warning: SQL error: [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS, SQL state S1000 in SQLConnect in c:\program files\apache group\apache\htdocs\comerson\fasdab\causa.php on line 21
Warning: Supplied argument is not a valid ODBC-Link resource in c:\program files\apache group\apache\htdocs\comerson\fasdab\causa.php on line 27
Warning: Supplied argument is not a valid ODBC result resource in c:\program files\apache group\apache\htdocs\comerson\fasdab\causa.php on line 30
Warning: Supplied argument is not a valid ODBC-Link resource in c:\program files\apache group\apache\htdocs\comerson\fasdab\causa.php on line 45
I have an entry for PROMSGS (Y:\dlc8\promsgs) in the environment tab in system
properties.
Note that the database is on our UNIX box.
can you help me or you any ideas
