Hi Sören, Sören Auer wrote: > On 10/2/07, Patrick van Kleef <vos.ad...@openlinksw.com> wrote: > >> OpenLink provides a zip file with a complete build of VOS, now >> including also the binary and support libraries for php5 hosting: >> >> http://virtuoso.openlinksw.com/wiki/main/Main/VOSDownload >> > > Thanks, that helps indeed. However, I think the installation for > novices would be eased a lot if the archive would contain a INSTALL > document (if you like with a pointer to a web page) where the > installation is explained step by step. > > I used http://virtuoso.openlinksw.com/wiki/main/Main/VOSMakeWindows as > a basic guideline and encountered the following problems: > > When trying to start virtuoso-php5-t.exe it complains about not being > able to find libvirtuoso-t.dll. After copying libvirtuoso-t.dll from > lib to bin it seems to work. >
To the basic installation steps from http://virtuoso.openlinksw.com/wiki/main/Main/VOSUsageWindows could be added following in regard to Virtuoso with PHP hosting : The PATH variable in the system wide environment must have : <Virtuoso dir>\bin;<Virtuoso dir>\lib;<REST of the PATH> This should be settable (at lest in XP) via My Computer (right click) -> Properties-> Advanced (tab) -> Environment Variables , in the PATH variable in system section. Please note that it's important that rest of existing PATH variable MUST be kept, i.e. the Virtuoso's install paths mentioned above should be appended before or after existing PATH, *not* over it. Once this is done, then OS needs to be re-started in order these settings to be in effect and service should be possible to be created. > The service creation somehow does not work on my machine (can that be > related to Vista?). > > Where does the PHP installation come from? Does Virtuoso contain a > whole PHP distribution? If so I'm wondering why the following error > occurs: > > PHP Startup: Unable to load dynamic library 'C:/Program > Files/PHP/ext/php_redland.dll' - The specified procedure could not be > found. > > How does Virtuoso magically know I installed PHP in C:/Program > Files/PHP? Does it really use that one? > The binary package contains virtuoso-php5-t.exe and php5ts.dll, the php5ts.dll coming from php site (latest windows distribution) so if you prefer to use your installation then just put the "<Virtuoso dir>\lib"; at the end of the PATH setting, then your install will take precedence. In the case you describe the virtuoso-php5-t finds the php5ts.dll in your installation first and uses it, this is how it detects you are installed PHP. > >> Virtuoso has different binaries that support various hosting modes. >> For your project you should use the virtuoso-odbc-php5-t binary >> instead of the default virtuoso-odbc-t binary. >> > > I did not find virtuoso-odbc-php5-t, however with virtuoso-php5-t ODBC > seems to be available as a module for PHP. > > Yes, the virtuoso-php5-t.exe is one available from Virtuoso Open-Source edition. >> A typical ODBC entry would have the following settings: >> [Virtuoso] >> Driver =3D /path/to/dll >> Address =3D localhost:1111 >> > > Where should that go? > First you need to register the Virtuoso ODBC driver as described in http://virtuoso.openlinksw.com/wiki/main/Main/VOSUsageWindows. Then you use the ODBC Administrator via Control panel : Administrative tools -> ODBC datasources to setup a DSN . Can use the document http://docs.openlinksw.com/virtuoso/odbcimplementation.html#virtdsnsetup , just read in point 5. "Select Driver named "Virtuoso (Open Source)". Note for the port value you use 1111 or 1112 depending where you started the Virtuoso server instance, the 1111 is set for <install>var\lib\virtuoso\db the other is for var\lib\virtuoso\demo , can check the ServerPort in Parameters section of the relevant INI file in server working directory . > In PHP I have the following function: > > odbc_connect(string $dsn, string $user, string $password) > > What shall I use for $dsn? I tried different things but always get the > following error: > > SQL error: [Microsoft][ODBC Driver Manager] Data source name not found > and no default driver specified, SQL state IM002 in SQLConnect > In the odbc_connect you should use for $dsn the name you entered in the driver setup done in above steps. I hope this helps. Best Regards, Mitko > Thanks for your help! > > Sören > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > 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
