Hi Team,
We need to send the data to downstream systems, which is MariaDB hosted in aws environment. I am trying to connect to the MariaDB through MySQL odbc drivers. When i am trying to connect to the Maria db it is giving below error for the first time of connection, once this error popup closed again if try to connect then it is connecting successfully. Screen shot given below. After Building the application & we ran the application due to connection fail (Object Cannot be cast from DBNull to others types) and returning -1 the application is closing. Can any one help on this. Which MySQL Driver i need to use to avoid this error.
Note : if we run the client server application it has been successfully communicate with Maria DB
Environment : Windows
PB : 2022 R3 Build 3289
Regards,
Vijay.
1) Create a C/S PB App EXE utility that connects to your primary DB and then transfers the respective datum to the MariaDB.
2) Install this utility on the same machine as the PS Server.
3) Use the MS-Windows "scheduler" to run this utility on a convenient interval.
That should then synchronize the MariaDB with the data it needs for further processing.
HTH