python - installing Pyodbc with Jython? -

-

platform: windows 7 (64 bit), jython version 2.7.10 "final release".
using java.sql classes access ms access dbases.

at point in future want move linux. @ point in future want move mysql/mariadb...

i thought it'd use more pythonic way, , seemed pyodbc might way go.

this attempt use pip install it:

d:\apps\jython2.7.0\bin>pip install pyodbc downloading/unpacking pyodbc   downloading pyodbc-3.0.10.tar.gz (68kb): 68kb downloaded   running setup.py (path:c:\users\chris\appdata\local\temp\pip_build_chris\pyodb c\setup.py) egg_info package pyodbc      warning: no files found matching 'tests\*'     warning: no files found matching 'readme.rst' installing collected packages: pyodbc   running setup.py install pyodbc     building 'pyodbc' extension     error: compiling extensions not supported on jython     complete output command d:\apps\jython2.7.0\bin\jython.exe -c "import s etuptools, tokenize;__file__='c:\\users\\chris\\appdata\\local\\temp\\pip_build_ chris\\pyodbc\\setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__). read().replace('\r\n', '\n'), __file__, 'exec'))" install --record c:\users\chri s\appdata\local\temp\pip-xb4a39-record\install-record.txt --single-version-exter nally-managed --compile:     running install  running build  running build_ext  building 'pyodbc' extension  error: compiling extensions not supported on jython  ---------------------------------------- cleaning up... ←[31mcommand "d:\apps\jython2.7.0\bin\jython.exe -c "import setuptools, tokenize ;__file__='c:\\users\\chris\\appdata\\local\\temp\\pip_build_chris\\pyodbc\\setu p.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\ n', '\n'), __file__, 'exec'))" install --record c:\users\chris\appdata\local\tem p\pip-xb4a39-record\install-record.txt --single-version-externally-managed --com pile" failed error code 1 in c:\users\chris\appdata\local\temp\pip_build_ch ris\pyodbc ←[0m←[31mstoring debug log failure in c:\users\chris\.pip\pip.log ←[0m d:\apps\jython2.7.0\bin>

anyone know whether can remedied/worked around?
have alternative suggestion pythonic access dbases using jython?

when move linux no longer have microsoft access odbc driver available (it windows-only). there other odbc options working access databases on non-windows platforms can less ideal.

for cross-platform solution use jython ucanaccess jdbc driver described in answer here:

read access database in python on non-windows platform (linux or mac)


Comments

Post a Comment

Popular posts from this blog

php - Invalid Cofiguration - yii\base\InvalidConfigException - Yii2 -

-
Image
i've installed yii2-user module/dektrium yii2-app-basic application command composer require "dektrium/yii2-user:0.9.*@dev" config/console.php return [ . . 'modules' => [ 'gii' => 'yii\gii\module', 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] config/web.php 'components' => [ . . /* 'user' => [ 'identityclass' => 'app\models\user', 'enableautologin' => true, ], */ 'modules' => [ 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] after that, run command $ php yii migrate/up --migrationpath=@vendor/dektrium/yii2-user/migrations updating database schema . but, when run http://localhost/mylawsuit/yii/web/index.php?r=u
Read more

How to show in django cms breadcrumbs full path? -

-
need advice - how show in breadcrumbs whole path article or page? i've got code: {% ance in ancestors %} <li> {% if not forloop.last %} <a href="{{ ance.get_absolute_url }}">{{ ance.get_menu_title }}</a> {% else %} <span class="active">{{ ance.get_menu_title }}</span> {% endif %} </li> {% endfor %} but shows "home" , current page. how modify show whole path in breadcrumbs? i've found in file menu_tags.py code calls ancestors. @ least there class showbreadcrumbs: class showbreadcrumb(inclusiontag): """ shows breadcrumb node has same url current request - start level: after level should breadcrumb start? 0=home - template: template used render breadcrumb """ name = 'show_breadcrumb' template = 'menu/dummy.html' options = options( argument('start_level', default=0, require
Read more

ruby on rails - npm error: tunneling socket could not be established, cause=connect ETIMEDOUT -

-
i have app uses rails framework , implements angularjs part of front end. i have pushed heroku , have heroku toolbelt installed, when try migrate db using "heroku run rake db:migrate" receive following error(s): installing core plugins heroku-cli-addons, heroku-apps, heroku-fork, heroku-git, heroku-local, heroku-run, heroku-status... error installing package. try running again gode_debug=info see more output. ! `run` not heroku command. ! perhaps meant `-h`, `2fa`, `auth`, `join`, `open`, `orgs`, `pg`, `ps` or `rake`. ! see `heroku help` list of available commands. i run command "gode_debug=info heroku run rake db:migrate" , receive error: npm err! darwin 14.5.0 npm err! argv "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/bin/node" "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/lib/node_modules/npm/cli.js" "install" "heroku-cli-addons" "heroku-apps" "heroku-fork
Read more