I am looking for some help using Python to connect to an Oracle 7.3 .rdb file on OpenVMS 8.4
We are trying to move away from Datatrieve in our environment and use Python to access our .rdb database file directly. But I am having trouble getting a module that works… I am not very knowledgeable in Python or its modules… I can SQL into our .rdb file without issue. But when I use sqlite3 in Python, it is not able to read the database file.. in openvms i ‘set default’ into the .rdb directory, then run Python…
$ python
Python 3.10.0 (default, Oct 17 2022, 09:12:23) [C] on OpenVMS
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> db_connection =sqlite3.connect('database.rdb')
>>> db_curs=db_connection.cursor()
>>> type (db_curs)
<class 'sqlite3.Cursor'>
>>> db_curs.execute("select * from table where sin=*********;")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
sqlite3.DatabaseError: file is encrypted or is not a database
The server is not online… I do have the Python wheels package, but it does not have access to other modules like pyodbc, or records, or SQLalchemy.. I am assuming someone has a way to do this… is there a module I can download somewhere? or maybe a different way to do this entirely…