/build/static/layout/Breadcrumb_cap_w.png

i used to be able to inquire to the Kace database (MySQL) prior to the release of Kace 14.1.98 (patch2) - now get a runtime error when i try to connect to it. -2147467259 (8000-4005). any suggestions?

Add your rating:--------------------

i used to be able to inquire to the Kace database (MySQL) prior to the release of Kace 14.1.98 (patch2) - now get a runtime error when i try to connect to it. -2147467259 (8000-4005). any suggestions?  i am using Excel vba to establish the connection.  I still look at ORG1 database and same R1 User name and the same default password for read access. 
Does anyone have any suggestions of what to try...  Here is my connectionstring.   

= "DRIVER={MySQL ODBC 5.3 Unicode Driver};SERVER=192.168.151.36;DATABASE=ORG1;UID=R1;PWD=box747;OPTION=3306"


0 Comments   [ + ] Show comments

Answers (1)

Posted by: lezotho 3 weeks ago
Senior Yellow Belt
0

If possible, update your ODBC driver, I see the latest is 9.2.

There shouldn't be any reason it wouldn't work on the latest version, unless older versions of ODBC are not compatible with the newer versions of MySQL/FreeBSD on the latest versions of the SMA.

If you do and still having issues, feel free to submit a ticket here.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ