Hi Jennie,

Actually I tried to edit the file pyapi_locatepython.bat as it is called from the M5server.bat to handle python loading options.

Please note that i uninstalled python 2.7 and i only have python 3.6 installed.

new pyapi_locatepython.bat content:

set LOCALPYTHONHOME=C:\Python36

set LOCALPYTHONPATH=C:\Python36\Lib

IF defined LOCALPYTHONHOME (

endlocal & (

set PYTHONHOME=%LOCALPYTHONHOME%

set PYTHONPATH=%LOCALPYTHONPATH%

set MONETDBPYTHONUDF=embedded_py=true

set "PATH=%LOCALPYTHONHOME%;%PATH%"

)

) ELSE (

@echo MonetDB/Python Disabled: Python 3.6 installation not found.

endlocal

)

I am having this error:

!SyntaxException:parseError:

!LoaderException:loadLibrary:Loading error failed to open library pyapi (from wi

thin file 'C:\Program Files\MonetDB\MonetDB5\lib\monetdb5\lib_pyapi.dll'):

!SyntaxException:parseError:

!<identifier> expected

Thank you.

On Thu, Aug 10, 2017 at 5:51 PM, Ying Zhang <Y.Zhang@cwi.nl> wrote:

Hai Imad,

You can pass different values to the embedded_py option of mserver5:

--set embedded_py=2
--set embedded_py=3
--set embedded_py=true

Or if you use merovingian:
$ monetdb set embedded_py=2 <database name>
$ monetdb set embedded_py=3 <database name>
$ monetdb set embedded_py=true <database name>

The value 2 or 3 obviously tell mserver5 to use Python 2 or Python 3, respectively. The value “true” will cause your default Python version to be loaded.

Does this help?

Best,
Jennie

> On 10 Aug 2017, at 09:52, imad hajj chahine <imad.hajj.chahine@gmail.com> wrote:
>
> Hi,
>
> I have been successfully using monetdb (11.25.3) on windows with embedded python 2.7, recently I needed a library that is only supported on python 3.6, is it possible somehow to point monetdb to the python 3.6 folder?
>
> I know this is possible on linux, but my dev environment is on windows.
>
> Thank you.

> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list