[gtopala]

Andrei Topala wrote siw2odbc. Please check https://www.gtopala.com/siw-report/reports.php

[swimboy]

I've noticed that the app has trouble escaping quotation marks. In my xml file I have:

<item Name="AMD driver update for AMD-8111 AC'97 Audio Controller Driver" Severity="" HotFix="" Category="" Date="10/28/2017" Client="Device Driver Retrieval Client" idx="7" />

But when I try to import the file, I get the following error:

INSERT INTO siw_Installed_Updates (siw_computer_id, siw_property_id, siw_name) VALUES ('33', 7, 'AMD driver update for AMD-8111 AC'97 Audio Controller Driver')
Datasource: [SIW] [MariaDB ODBC 3.0 Driver] [MariaDB 10.02.000008 siw][42000] [ma-3.0.2][10.2.8-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '97 Audio Controller Driver')' at line 1 (1064)
DSN=[SIW] RETCODE=-1

[gtopala]

I've noticed that the app has trouble escaping quotation marks. In my xml file I have:

<item Name="AMD driver update for AMD-8111 AC'97 Audio Controller Driver" Severity="" HotFix="" Category="" Date="10/28/2017" Client="Device Driver Retrieval Client" idx="7"  />

But when I try to import the file, I get the following error:

INSERT INTO siw_Installed_Updates (siw_computer_id, siw_property_id, siw_name)  VALUES ('33', 7, 'AMD driver update for AMD-8111 AC'97 Audio Controller Driver')
Datasource: [SIW] [MariaDB ODBC 3.0 Driver] [MariaDB 10.02.000008 siw][42000] [ma-3.0.2][10.2.8-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '97 Audio Controller Driver')' at line 1 (1064)
DSN=[SIW] RETCODE=-1

siw2odbc was tested with MySQL ANSI ODBC Driver, not with MariaDB ODBC Driver.
I guess that siw2odbc is unable to get the escape character from MariaDB ODBC Driver.
Please send me the result of the following statement:
SELECT * FROM siw_computers;

[swimboy]

Code:

MariaDB [siw]> SELECT * FROM siw_computers;
+-----------------+-------------------+-----------------------------------------+--------------------------+
| siw_computer_id | siw_computer_name | siw_version                             | siw_date                 |
+-----------------+-------------------+-----------------------------------------+--------------------------+
|               1 | DESKTOP-FTFKR9D   | SIW 2017 v7.7.1029 Technician's Version | Sun Oct 29 12:37:58 2017 |
+-----------------+-------------------+-----------------------------------------+--------------------------+
1 row in set (0.00 sec)

[gtopala]

Code:

MariaDB [siw]> SELECT * FROM siw_computers;
+-----------------+-------------------+-----------------------------------------+--------------------------+
| siw_computer_id | siw_computer_name | siw_version                             | siw_date                 |
+-----------------+-------------------+-----------------------------------------+--------------------------+
|               1 | DESKTOP-FTFKR9D   | SIW 2017 v7.7.1029 Technician's Version | Sun Oct 29 12:37:58 2017 |
+-----------------+-------------------+-----------------------------------------+--------------------------+
1 row in set (0.00 sec)

siw2odbc 2017 v7.8.1111: added support for MariaDB ODBC drivers
Please download it from https://www.gtopala.com/thank-you/siw2odbc.php