Hi,
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.
Any ideas anyone. I'm really stuck on this one!
Thanks in advance,
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.
Any ideas anyone. I'm really stuck on this one!
Thanks in advance,
