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 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"
Answers (1)
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.