odbc for solid

[flupke]

Hi,

at work we use a solid database and i need to develop an application
that accesses it. Problem is the drivers: i only have some dll's lying
around and jar.
On winsdows i could get by by using ODBC and the dll's to access the
solid database but i want to eventually run it on a linux server.
Solid doesn't seem to have a driver specifically for Linux so i'm stuck
here. Is there any way i can still use Linux and have access to solid?
Maybe i need to revert to jython so i can use the jar?

Thanks for any info
Benedict

[Steve Holden]

Re: odbc for solid

flupke wrote:
[color=blue]
> Hi,
>
> at work we use a solid database and i need to develop an application
> that accesses it. Problem is the drivers: i only have some dll's lying
> around and jar.
> On winsdows i could get by by using ODBC and the dll's to access the
> solid database but i want to eventually run it on a linux server.
> Solid doesn't seem to have a driver specifically for Linux so i'm stuck
> here. Is there any way i can still use Linux and have access to solid?
> Maybe i need to revert to jython so i can use the jar?
>[/color]

This might be of interest (and also possibly of relevance to an earlier
query about accessing MS SQL Server from Unix in the "Python, unix and
mssql" thread):

http://sourceforge.net/projects/pyodb

"""PyODB is an ODBC Python module to provide an quick an easy way to
work with databases. It provides a small set of simplified bindings to
the unixODBC API and has been developed using SWIG."

regards
Steve
--
Steve Holden http://www.holdenweb.com/
Python Web Programming http://pydish.holdenweb.com/
Holden Web LLC +1 703 861 4237 +1 800 494 3119

[flupke]

Re: odbc for solid

> Steve Holden wrote:[color=blue]
>
> This might be of interest (and also possibly of relevance to an earlier
> query about accessing MS SQL Server from Unix in the "Python, unix and
> mssql" thread):
>
> http://sourceforge.net/projects/pyodb
>
> """PyODB is an ODBC Python module to provide an quick an easy way to
> work with databases. It provides a small set of simplified bindings to
> the unixODBC API and has been developed using SWIG."
>
> regards
> Steve[/color]

Thanks Steve, i'll check the link

Benedict

[Benji York]

Re: odbc for solid

flupke wrote:[color=blue]
> On winsdows i could get by by using ODBC and the dll's to access the
> solid database but i want to eventually run it on a linux server.[/color]

ODBTP (http://odbtp.sourceforge.net/) allows you to hit Windows ODBC
drivers over the network from any machine with a C compiler. If it
sounds like something you'd want to use, download my python interface
(being merged into the main project soon-ish) from
http://benjiyork.com/odbtp.html.
--
Benji York

[Michele Petrazzo]

Re: odbc for solid

flupke wrote:[color=blue]
> Hi,
>
> at work we use a solid database and i need to develop an application
> that accesses it. Problem is the drivers: i only have some dll's lying
> around and jar.
> On winsdows i could get by by using ODBC and the dll's to access the
> solid database but i want to eventually run it on a linux server.
> Solid doesn't seem to have a driver specifically for Linux so i'm stuck
> here. Is there any way i can still use Linux and have access to solid?
> Maybe i need to revert to jython so i can use the jar?
>
> Thanks for any info
> Benedict[/color]

I have create RealPyOdbc, that is a class made in pure python that
create a simple interface from python to odbc with the use of ctypes.
Of course, it work on every system where ctypes work (win, linux, mac).

It has no db-api 2.0 compatible (my free time is very low), but the work
for make it compatible is very low.

You can see it here:

https://www.unipex.it/vario/RealPyOdbc.py

In the future, when I'll finish it (make the db-api 2), I'll open a
sf.net project.

I hope it will help you.

Bye,
Michele Petrazzo