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
