Issues with ODBC Connection to Pervasive Database

Scriptcase 7 Discussion
#1

I am trying to setup a ODBC connection within Scriptcase to link to one of our Pervasive Databases. We have setup the Data source using the Data Sources Connections within Control Panel.

When we then try and access this within scriptcase using the Test Connection it just seems to hang. I was wondering whether anyone had any experience in setting up a connection to a Pervasive Database. We have a set of DDF files installed within the same folder at the database tables and have been able to access the details via the Pervasive Control Center and other tools such as Crystal Reports.

I was wondering if we needed to have a specific drivers setup within the configuration of scriptcase or if there is something simple I am missing. Are there any log files which may throw some light on the problem,

Using Pervasive SQL 9.5 and Scriptcase Enterprise v7 on a Windows 7 machine.

Andy

#2

First I would try to connect with standard php. Does this work?


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>PHP Sample</TITLE>
</HEAD>
<BODY>
<?php
$conn=odbc_connect("Demodata","","","");
$sql="select * from class";
$rs=odbc_exec($conn,$sql); 
echo "<table border=1>
";
$numfields = odbc_num_fields($rs);
for($i=1;$i<=$numfields;$i++){
    $fn=odbc_field_name($rs,$i);
    echo "<th>$fn</th>";
}
echo "
";
while(odbc_fetch_row($rs)){
    echo "<tr>
";
    for($i=1;$i<=$numfields;$i++){
       $fv=odbc_result($rs,$i);
       echo "<td>$fv</td>";
    }  
    echo "</tr>
";
}
echo "</table>
";
echo "<p>Number of Fields: $numfields</p>
";
?>
</BODY>
</HTML>