Hi Sören, I found that odbc driver causes this problem. We have a fix for it so we will update the driver soon.
Best Regards, Mitko Mitko Iliev wrote: > Hi Sören, > > I tried the case locally, but just getting : > > Warning: PHP Startup: SQL error: [OpenLink][Virtuoso ODBC > Driver][Virtuoso Server]SQ074: Line 1: syntax error at '*' before > 'FROM', SQL state 37000 in SQLExecDirect in > C:\dbs\var\lib\virtuoso\vsp\vos1.php on line 3 > Warning: odbc_result_all(): supplied argument is not a valid ODBC result > resource in C:\dbs\var\lib\virtuoso\vsp\vos1.php on line 4 > > There are two things that can be tried: > - need to check if this is inside php lib as > * make the c:\<vos-dir>\lib to take precedence to the your PHP install > path, i.e. the c:\<vos-dir>\lib to be at the front of the PATH. > OR just temporarily rename the php5ts.dll in your PHP install to > something else . > The idea is to use the php5ts.dll which is in the binary package, > i.e. one used to link against it. > * run the virtuoso-php5-t and repeat the experiment, see if it crashes > > - rename the php.ini from PHP install, so it can be seen if there is an > startup option causing one of virtuoso-php5-t, virtodbc.dll & php5ts.dll > to crash > run the virtuoso-php5-t and repeat the experiment, see if it crashes > if it doesn't crash lpease send me your php.ini so i can try to > reproduce locally and debug etc. > > - if non of the above makes it to work, then please enable Drwtsn32 to > do mini-dump, the procedure is as follows : > * run from command line "Drwtsn32 -i", should say installed > * run Drwtsn32 again and configure to do mini-dump > * repeat the experiment , when it crashes the drwtsn should produce > a user.dmp (or whatever is speicfied in it's config screen) > so if you get a mini dump, please send it to us so we can try to see > in which component is it. > > Best Regards, > Mitko > > Sören Auer wrote: > >> On 10/3/07, Hugh Williams <hwilli...@openlinksw.com> wrote: >> >> >>> 1. Confirm the Version of the Virtuoso ODBC Driver being used which can be >>> obtain from the Drivers Tab of the ODBC Administrator >>> >>> >> The drivers tab contains for Virtuoso: >> >> Name: Virtuoso (Open Source) >> Version: Not marked >> Company: Not marked >> File: VIRTODBC.DLL >> Date: 10/2/2007 >> >> i.e. I downloaded and installed the package >> virtuoso-opensource-win32-5.0.2.zip >> >> >> >>> 2. Provide and ODBC trace of the attempted connection such that we can see >>> where in the ODBC layer the failure is occurring possibly. >>> >>> >> I just tried many times to produce the log, but the log-file is simply >> not created :-( Must be a Vista bug. >> >> >> >>> 3. Provide a copy of your virtuoso.log such that we can see if any errors >>> are reported here. >>> >>> >> Is attached. >> >> 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 >> > > > -- Mitko Iliev Developer Virtuoso Team OpenLink Software http://www.openlinksw.com/virtuoso Cross Platform Web Services Middleware
