DHI / DHI/mikepluspy

Issues using DataTableAccess (rookie issue)

Open
#33 5 comments 0 reactions 1 assignee Claimed by @ryan-kipawa View on GitHub
bug
Dominant language
Python
Stars
25
Forks
3
PR merge metrics
No merged PRs in 30d

Description

Hello.
I have previously used both mikeio and mikeio1D with great succes. I am now trying to get started using mikepluspy following the examples on here. I simply run the code below, which causes the error also seen below.
I am using anaconda + spyder (Python 3.11), which hasn't caused any issues with mikeio and mikeio1D, when installing using pip in the anaconda prompt. Similarly I am using mike+ 2024 for both mikepluspy and mike+.

import mikeplus
from mikeplus import DataTableAccess
from mikeplus.engines import Engine1D
import clr
import os

dta = DataTableAccess(test.sqlite)
dta.open_database()
dta.is_database_open()

Which results in the error:
SQLiteException: code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error
The specified module could not be found.
at DHI.Amelia.DataModule.Services.DataSource.DataSourceSpatiaLite.OpenDatabaseCore()
at DHI.Amelia.DataModule.Services.DataSource.BaseDataSource.OpenDatabase()

I have tried also including the following, which did not help, as well as trying to clr.AddReference() the two modules above, but perhaps that doesn't make sense, at least it did not work.
clr.AddReference("System")
clr.AddReference("System.Runtime")
clr.AddReference("System.Threading")
clr.AddReference("System.Runtime.InteropServices")
clr.AddReference("DHI.Amelia.DataModule")
clr.AddReference("DHI.Amelia.DataModule.Interface")
clr.AddReference("DHI.Amelia.Infrastructure.Interface")
clr.AddReference("DHI.Amelia.GlobalUtility")
clr.AddReference("DHI.Amelia.DomainServices")
clr.AddReference("DHI.Amelia.DomainServices.Interface")

I hope this is the correct place to post my issues, otherwise feel free to direct my to another place.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.