Re: PROGRESS SQL_CUR_USE_ODBC

"Kristen G. Thorson" <kthorson@xxxxxxxxxxxxxxxxxxxxxx> · Tue, 04 Oct 2005 14:27:21 -0400

cybermalandro cybermalandro wrote:

Thanks for your prompt response! Are you using the pear DB class 
requiring odbc? I am not very familiar with this class and pear. I was 
trying to do it the old way.  Perhaps you can give me some more 
examples? I really appreciate your help.

Thanks

On 10/4/05, *Kristen G. Thorson* <kthorson@xxxxxxxxxxxxxxxxxxxxxx 
<mailto:kthorson@xxxxxxxxxxxxxxxxxxxxxx>> wrote:

    cybermalandro cybermalandro wrote:

    >I am connecting to a PROGRESS DB through the MERANT ODBC driver,
    When I have
    >the 4th parameter SQL_CUR_USE_ODBC as shown, my queries return
    nothing but
    >if I have the 4th parameter as lower case it returns my query
    results but
    >with a PHP error complainning
    >*Notice*: Use of undefined constant sql_cur_use_odbc - assumed
    >'sql_cur_use_odbc'
    >
    >Wtf? I don't get it, most of the documentation from people
    connecting to
    >PROGRESS do have the 4th parameter uppercase can someone help me
    out ?
    >
    >Thanks!
    >
    >
    >

    Using PEAR:DB with this dsn I can connect and get results:

    $dsn =
    "odbc(Progress_SQL92_Driver)://$username:$password@$protocol+$ip:$port/$database?cursor=SQL_CUR_USE_ODBC";

    kgt

I think I was using iODBC and the PEAR DB class.  I actually did this a 
long time ago.  I have this script sitting on my hard drive and I know I 
had a working solution at one point in time, so I'm assuming this was 
it.  I don't have the test environment set up anymore, so I can't really 
check.  Following is the script I have to print the contents of the 
Customer table in the Sports database.  It looks like I took a PEAR:DB 
example and just modified it to work with Progress, so I'm certain 
there's much room for improvement.

require_once '/usr/share/pear/DB.php';    

// Get the connection variables:
require_once 'dbinfo.php';

$dsn = 
"odbc(Progress_SQL92_Driver)://$username:$password@$protocol+$ip:$port/$database?cursor=SQL_CUR_USE_ODBC"; 

// Creates a database connection object in $db or, a database error 
object if it went wrong.
// The boolean specifies this is a persistent connection like 
mysql_pconnect(), it
// defaults to FALSE.
$db = DB::connect($dsn, TRUE);

// Check whether the object is a connection or
if (DB::isError($db)) {      

   /*
    * This is not what you would really want to do in
    * your program.  It merely demonstrates what kinds
    * of data you can get back from error objects.
    */
   echo 'Standard Message: ' . $db->getMessage() . "<br>\n";
   echo 'Standard Code: ' . $db->getCode() . "<br>\n";
   echo 'DBMS/User Message: ' . $db->getUserInfo() . "<br>\n";
   echo 'DBMS/Debug Message: ' . $db->getDebugInfo() . "<br>\n";
   exit;

                               // an error.
   //die($db->getMessage());     // Print out a message and exit if it's
                               // an error object.
}

// Get a connection as above

$sql = "SELECT * from PUB.Customer";   // Build your SQL query

$res = $db->query($sql);
if (DB::isError($res)) {        // Check the result object in case there
   die($res->getMessage());    // was an error, and handle it here.
}

echo "<table cellpadding=0 cellspacing=0 border=0>";
echo "<tr><th>Cust Num</th>";
echo "<th>Name</th>";
echo "<th>Address</th>";
echo "<th>Address2</th>";
echo "<th>City</th>";
echo "<th>State</th>";
echo "<th>Country</th>";
echo "<th>Phone</th>";
echo "<th>Contact</th>";
echo "<th>Sales-Rep</th>";
echo "<th>Comments</th>";
echo "<th>Credit-Limit</th>";
echo "<th>Balance</th>";
echo "<th>Terms</th>";
echo "<th>Discount</th>";
echo "<th>Postal-Code</th></tr>";

while ($row = $res->fetchRow(DB_FETCHMODE_ASSOC)) {
   // Fetch a row from the result resource object $res.
   // DB_FETCHMODE_OBJECT returns a row with column names as keys.
   // Other possibilities are listed here:
   // http://pear.php.net/manual/en/core.db.tut_fetch.php

   if (DB::isError($row)) {
       //fetchRow can return an error object like most PEAR::DB methods
       die($row->getMessage());
   } else {
       echo "<tr><td>" . $row["Cust-Num"] . "</td>\n";
       echo "<td>" . $row["Name"] . "</td>\n";
       echo "<td>" . $row["Address"] . "</td>\n";
       echo "<td>" . $row["Address2"] . "</td>\n";
       echo "<td>" . $row["City"] . "</td>\n";
       echo "<td>" . $row["State"] . "</td>\n";
       echo "<td>" . $row["Country"] . "</td>\n";
       echo "<td>" . $row["Phone"] . "</td>\n";
       echo "<td>" . $row["Contact"] . "</td>\n";
       echo "<td>" . $row["Sales-Rep"] . "</td>\n";
       echo "<td>" . $row["Comments"] . "</td>\n";
       echo "<td>" . $row["Credit-Limit"] . "</td>\n";
       echo "<td>" . $row["Balance"] . "</td>\n";
       echo "<td>" . $row["Terms"] . "</td>\n";
       echo "<td>" . $row["Discount"] . "</td>\n";
       echo "<td>" . $row["Postal-Code"] . "</td></tr>\n";
   }
}

echo "</table>";
$res->free();
$db->disconnect();              // Close the connection.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php