Send Bacnet values to SQL db
Is it possible to set a SQL server as a publisher please?
If not, is there another way to send data from Mango to a SQL server please?
JoelHaggar last edited by
You can use the SQL Data Source to pull in and push out data using custom SQL Queries. It's very flexible.
Thanks for your reply.
I'm very new to all this, so slowly finding my way around.
I wonder if you could help me please? I'm struggling slightly to get Mango to connect to my MS SQL 2014 server.
I currently have the following connection settings
Driver class name :- com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection String :- jdbc:sqlserver://localhost;database=WeatherData;integratedSecurity=false;
Select Statement :- select dbo.futureValues(351033,'F',6)
When I press the Execute button all that I see is "Executing select statement..." no error, and no values.
If I go to SQL Server Management Studio, and execute the command, I receive a value back.
What am I doing wrong please?
After a bit of digging around on Google, it turns out that it was simply the fact that TCP/IP connections were not enabled by default within SQL Express.
Enabled, and now working :-)