Hi Soren,

Can you please provide the following:

1. Confirm the Version of the Virtuoso ODBC Driver being used which can be
obtain from the Drivers Tab of the ODBC Administrator

2. Provide and ODBC trace of the attempted connection such that we can see
where in the ODBC layer the failure is occurring possibly.

3. Provide a copy of your virtuoso.log such that we can see if any errors
are reported here.

Best Regards,
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers


On 3/10/07 21:48, "Sören Auer" <soeren.a...@gmail.com> wrote:

> When sending malformed SQL via ODBC to Virtuoso virtuoso-php5-t
> crashes without any error.
> I'm executing the following PHP:
> 
> $db=odbc_connect('virtuoso','dba','dba');
> $result = odbc_exec($db,'SELECT * FROM DB.DBA.SYS_USERS');
> print_r(odbc_result_all($result));
> 
> everything works fine and as expected. If I add a typo to the SQL
> query, such as 'aSELECT * FROM DB.DBA.SYS_USERS' the service crashes
> without any error message and I have to restart it manually.
> Since we want to port a larger application from MySQL's SQL to
> Virtuoso'SQL, where the syntax unfortunately differs at quite a few
> places, it is almost impossible to debug the SQL code.
> Any ideas what could be the reason and how to solve this?
> 
> Sören
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users






Reply via email to