9/14/2018 4:41 PM | |
Joined: 2/6/2009 Last visit: 6/10/2024 Posts: 46 Rating: (23) |
Hello, I have perform test with two virtual machines one with SQL 2012 stdn and second with EnMPRO, but i cannot get data. SQL server is configured for remote access - I can connect from another PC and SQL instance to this DB remotely. In EnMPRO I have configured OLE DB driver as in attached pdf file, and connection wizard connection test said it is OK, and DB, table and columns are visible. I also Restarted kernel for this connection after configuration as it is stated in manual. But when I populate SQL table with some data I cannot get data in EnMPRO. What is my mistake? Could yyou be more precise about SQL table column data type format? What format should be timestamp column? Datetime format or something else? Is this format PC Station regional settings dependent? And what about name and value column? I have tested OLE DB driver with Local Access database and same range of data, and I got the same behavior. Wizard setup is OK but there is no data seen in datapoint->measurement window in EnMPRO Client. Thank you in advance! AttachmentEnMPRO_SQL_Connection.pdf (312 Downloads) |
Last edited by: VladD at: 9/17/2018 11:32:51 AM |
|