Marcel,
You should generate an ODBC trace (Tracing tab in the ODBC Administrator).
This will expose if the issue is in your Paradox driver, and what it is.
Either way, following up with the driver manufacturer would be a good idea.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -----Original Message-----
> From: Marcel Spaarman [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 07, 2001 9:06 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] ODBC and Memofields
>
>
> 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]
>
>
--
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]
