To anyone that may know...
I'm having a problem with the memofields in my Paradox Database.
My DSN cannot handle them and I don't know why.
All I get is an external error:
Warning: SQL error: [Microsoft][ODBC Paradox Driver] Unexpected error
from external database driver (28610)., SQL state S1000 in
SQLExecDirect in C:\HTTP_ROOT\release.php on line 10
This is my script:
<?
$connection = odbc_connect("ODBC_Connect","****","****")
or die("Couldn't connect to Database.");
$sql = "SELECT Catalog.LabelCopyFF, Release.ReleaseId
FROM Catalog, Release
WHERE Release.ReleaseId = Catalog.ReleaseId
AND Release.Title = '$name'";
$sql_result = odbc_exec($connection, $sql)
or die("Couldn't execute statement.");
while ($record = odbc_fetch_row($sql_result))
{
$resultaat = odbc_result ($sql_result,"LabelCopyFF");
echo "$resultaat";
}
odbc_free_result($sql_result);
odbc_close($connection);
?>
Can anyone please help me to handle this problem
Thnx !
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]