Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Send Bacnet values to SQL db
-
Hello,
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?Thanks,
Chris
-
Hi Chris,
You can use the SQL Data Source to pull in and push out data using custom SQL Queries. It's very flexible.
-
Hi Joel,
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 settingsDriver 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?
Thank you!!
-
Update,
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 :-)
