Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

python connect to OI mvdbs (OpenInsight 32-bit Specific)

At 29 JUN 2011 09:50:32PM Alex wrote:

is it possible for python access to OI multivalue database?

recently,i am learning python. If python able to access to OI mvdbs that would be great.

Google about "python OI", but no luck.

At 03 JUL 2011 05:03AM Eric wrote:

Might be possible via ODBC connectivity.

Do you want read or write access, or both?

At 04 JUL 2011 09:14PM Alex wrote:

Both if possible. ODBC? then i have to buy the OI ODBC. But before that i must know it work or not. Or some other way that is free ^_^

Thanks

At 05 JUL 2011 08:20AM Bob Carten wrote:

Hi Alex,

It should be possible to connect Python to OpenInsight using a socket connection to the Oengineserver. I have examples of this in PHP and Ruby, it should be easy to make one for Python. Also, using the windows scripting host plus IronPython it should be possible to embed Python inside of OpenInsight. I believe there are example scripts posted in the works section. If you cannot find them email info@revelation.com, we'll send you the php example.

- Bob

At 06 JUL 2011 05:53AM Alex wrote:

I am still using OI 7.2.1

Last year, i tried to setup oengineserver but failed. It give me some weird problem (forgot what is that) on win vista and above. Maybe i did something wrong.

If i not wrong , i remember i read some post about V7.2.1 oengine is not supported on win vista and above.

So i need some proper guide on setting up oengine first. Then later Ironpython. The Guide in "OIonlinehelp" is confusing.

Thanks

Alexlim@ctesb.com

At 06 JUL 2011 10:49AM Bob Carten wrote:

Hi Alex

Python has the ability to use COM objects. You could look at using xrev.dll. Python can call C dlls too, so you could just make DLL calls to revCap32.dll. You should consider moving to a newer release of OI if possible. The engineServer and the documentation are much better in current versions than in 7.21 The engineServer is the preferred approach for connecting from external clients.

- Bob

At 06 JUL 2011 11:51PM Alex wrote:

upgrade OI Version is up to my boss and manager (what i can do is suggest only).

May i have the python access to xrev.dll example code?

Thanks.

- Alex

alexlim@ctesb.com

At 08 JUL 2011 06:40PM Bob Carten wrote:

Hi Alex,

I sent you a vbScript example, it should be easy to translate to Python.

- Bob

View this thread on the forum...