LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Labview interface with MongoDb or similar NoSql database

Hi Hollowhorse,

Thanks for that swift reply.

Is it possible to access MongoDB using HTTP POST and GET methods?

Also, it possible to do the same using Wire Protocol (TCP Socket)?

Regards,

Saptarshi Pan

0 Kudos
Message 41 of 46
(674 Views)

Hi Saptarshi,

 

Well.... anything is possible 😉

I did look at using the HTTP POST and GET methods originally, but the functionality was very limited at the time.

It's definitely possible to use Wire protocol, but that means writing your own drivers from scratch. That's something which has always appealed to me, but I've never had the time (or foolhardiness) to try it.

 

Regards,

Hollowhorse

0 Kudos
Message 42 of 46
(665 Views)

Hi, Hollowhorse

What do I to get the N documents from MongoDB in LabView?

I tried a few things, but I believe it would be best if we can replicate this command line statement db.collectionName.find({"_id": 0}).sort({"_id": -1}).limit(100).pretty(). Can we do this using the RBX Systems Driver

0 Kudos
Message 43 of 46
(634 Views)

Hi Saptarshi,

 

That's an odd query seeing as MongoDB normally forces unique values for _id. In theory you can only ever have one instance where _id = 0. Regardless, I have written some LabVIEW code to replcate your query. I have to be honest, handelling .NET in LabVIEW is quite longwinded - so the code looks more complicated than it actually is. As I've said before, I'd advise encapsulating some of the common .NET driver functions into VI's.

 

hollowhorse_0-1582200637080.png

 

I'm afraid I can't comment on the RBX driver. At the time I was working on my project it didn't do what I needed, but it may have come on since then.

 

Regards,

hollowhorse

Download All
0 Kudos
Message 44 of 46
(623 Views)

Hi all,

 

I tried to access database with user/password without success.I have always same error:

 

Constructor Node Error creating instance of MongoClient in assembly MongoDB.Driver.MongoClient, MongoDB.Driver, Version=1.8.3.9, Culture=neutral, PublicKeyToken=f686731cfb9cc103, (System.NotSupportedException: Unsupported MongoAuthenticationMechanism SCRAM-SHA-1.) <append><b>System.NotSupportedException</b> in TestMongoDB.vi

 

Connection string like:

 

mongodb://user:passw@host/admin?authMechanism=SCRAM-SHA-1

 

What is wrong? Database is 4.0.

 

Thanks in advance!!!

 

0 Kudos
Message 45 of 46
(501 Views)

What would i need to do to open the MongDB Test.vi without having the project open.  I would like to add this to the code that I am currently working to develop some reusable code outside of a project scenario.

HMunster_0-1635254183154.png

It is broken without the project open and when I try to right click and select a constructer I can browse to the mongodb.driver.dll  but when opening I get "An error occurred trying to load assembly."

HMunster_1-1635254358097.png

I think this can sometimes be caused by one dll being dependent on another and that they may need to be in the same directory.  The MongoDB.Bson.dll and MongoDB.Driver.dll are in the same folder but the mscorlib.dll is not and I find 81 versions of this on my PC.  I tried moving a couple of them into the same folder but it did not help.

 

Is there a way to do this?

 

 

0 Kudos
Message 46 of 46
(200 Views)