ODBC and Memofields
| From: | (Marcel Spaarman) | Date: | Mon, 07 May 2001 13:05:35 +0000 |
| Subject: | ODBC and Memofields | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9149@lists.php.net to get a copy of this message | ||
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 !