EcoStruxure IT forum
Schneider Electric support forum about installation and configuration for DCIM including EcoStruxure IT Expert, IT Advisor, Data Center Expert, and NetBotz
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-03 10:32 PM . Last Modified: 2024-04-07 11:02 PM
Hello Team ,
We tried to used insight connect to external SQL DB to load some data , in first ,we connect SQL data
from insight successfully , when we publish the report format to DCO , there was an error occur when
we generated the report which the data was loaded from external SQL , please see as below screenshot,
We also download the log by DCO , found some message shows ''Cannot load JDBC Driver class:'' ,
The JDBC driver we download is from MySQL web site , May I know if it's the wrong JDBC driver we are used?
Which version or what's type for JDBC driver we should uesd for insight ?
Any configuration is require for DCO ?
Kindly help and it's would be appreciated .
Best Regards
(CID:124522911)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-03 10:33 PM . Last Modified: 2024-04-07 11:02 PM
Hi Chu Li,
It has been a while since I used it but from memory you need to load the same driver you are using to generate reports via Insights into your DCO client application installation directory:
The error you are getting seems to indicate the driver is missing from this location.
Please double check and load it in if not already there.
Also be mindful that all users who what to use this Custom DCO Report will need to do the same as their DCO clients will also require that same driver to be present.
Regards
Lukasz
(CID:124523193)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-03 10:33 PM . Last Modified: 2024-04-07 11:02 PM
Hello. It may be necessary to upload a driver to the DCO server so the connection to the external database is successful from the DCO server.
There is a page on EcoStruxure IT Help Center which describes this process for sql-server (pasted below). You should check whether the proper driver is installed for my-sql.
Regards
Greg Sterling
(CID:124522999)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-03 10:33 PM . Last Modified: 2024-04-07 11:02 PM
Hi Chu Li,
It has been a while since I used it but from memory you need to load the same driver you are using to generate reports via Insights into your DCO client application installation directory:
The error you are getting seems to indicate the driver is missing from this location.
Please double check and load it in if not already there.
Also be mindful that all users who what to use this Custom DCO Report will need to do the same as their DCO clients will also require that same driver to be present.
Regards
Lukasz
(CID:124523193)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-03 10:33 PM . Last Modified: 2024-04-07 11:02 PM
Hi Lukasz,
Just follow your instruction and can work now ,thank you so much : )
Best Regards
(CID:124523256)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-03 10:33 PM . Last Modified: 2024-04-07 11:02 PM
Not a problem have fun 😀
(CID:124523264)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-03 10:33 PM . Last Modified: 2024-04-07 11:02 PM
Hi Greg ,
We put the driver to DCO client folder then it can work ,thank you for advice .
Best Regards
(CID:124523254)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-03 10:33 PM . Last Modified: 2023-10-22 02:44 AM
This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.
Link copied. Please paste this link to share this article on your social media post.
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.