Export data to SQL

[tranduong257]

Hello,
I’m trying export data from Rapid to SQL server, i can’t connect Rapid to the Server, so I have some question:
1. Is it necessary to activate or get a license for ModBDExport.dll?
2. I see some query in documentation, Have I specify that query in Rapid only or in both Rapid and SQL Server Management?
Thank you so much.

[Mikhail]

Hi,
1. No, the module is free.
2. Specify the query in the module configuration.

If you provide screenshots of the module settings, I can check.

[jlemus]

Hi I have the same problem
I executed the sql scripts in the documentation creating the necesary tables in the database and configure the insert and update queries in the module configuration tabs.
then i configure the conection and nathing.

i think there must be something mising, for example how does the module knows wich channels to export?.

thanks in advance

[jlemus]

Im using Slq Server 2008R2
and Win10

[Mikhail]

Hi,
Module screenshots and logs appreciated.

how does the module knows wich channels to export?

The current version of the module exports all channels. In the next version, a user can specify the channels.

[jlemus]

thanks, the module worked out, I accidentaly had taken the postgre sql sample scripts instead of the sql server sample scripts.

thanks for the clarification on the channels topic. Hoping to see the next version soom.

[Mikhail]

The new Rapid SCADA 5.8.4 contains fully redesigned Export to Database module. I recommend to update.

[naser]

How I Connect Microsoft SQL Server With Rapid Scada Idid Setting as per the attachment but not working

Export To DB

Export To DB

Microsoft SQL Server

ModDbExport.log

ModDbExport_001.log

2023-03-23 09:39:49 Error connecting to DB:
MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. —> System.Net.Sockets.SocketException (0x80004005): No such host is known
at System.Net.Dns.GetAddrInfo(String name)
at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)
at System.Net.Dns.GetHostEntry(String hostNameOrAddress)
at MySql.Data.Common.MyNetworkStream.CreateStream(MySqlConnectionStringBuilder settings, Boolean unix)
at MySql.Data.Common.StreamCreator.GetStream(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Scada.Db.DataSource.Connect()
at Scada.Server.Modules.DbExport.Exporter.Connect()
2023-03-23 09:39:51 Error connecting to DB:
MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. —> System.Net.Sockets.SocketException (0x80004005): No such host is known
at System.Net.Dns.GetAddrInfo(String name)
at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)
at System.Net.Dns.GetHostEntry(String hostNameOrAddress)
at MySql.Data.Common.MyNetworkStream.CreateStream(MySqlConnectionStringBuilder settings, Boolean unix)
at MySql.Data.Common.StreamCreator.GetStream(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Scada.Db.DataSource.Connect()
at Scada.Server.Modules.DbExport.Exporter.Connect()
2023-03-23 09:39:52 Error connecting to DB:
MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. —> System.Net.Sockets.SocketException (0x80004005): No such host is known
at System.Net.Dns.GetAddrInfo(String name)
at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)
at System.Net.Dns.GetHostEntry(String hostNameOrAddress)
at MySql.Data.Common.MyNetworkStream.CreateStream(MySqlConnectionStringBuilder settings, Boolean unix)
at MySql.Data.Common.StreamCreator.GetStream(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Scada.Db.DataSource.Connect()
at Scada.Server.Modules.DbExport.Exporter.Connect()
2023-03-23 09:39:53 Error connecting to DB:

[Mikhail]

Hello,
Did you try entering IP address in the Server textbox?

[naser]

hello,

can you explain how I enter IP address in Server textbox ?

[Mikhail]

Hello,
See https://ibb.co/JkXJSmJ

[Author]

Posts