Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Powerserver & ODBC drivers

  1. Issue
0
Votes
Undo
  1. Vijay Kumar
    Vijay Kumar
  2. PowerServer
  3. Thursday, 11 April 2024 10:57 AM UTC

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.

"ErrorMessage": "ORA-01008: not all variables boun...
Antivirus software and Powerserver apps
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 11 April 2024 11:09 AM UTC
  2. PowerServer
  3. # 1

Hi Vijay;

  PS uses native DB drivers that are pulled down as a specific NuGet package from the DBMS vendor. Thus, PS would need to have access to a MariaDB NuGet odbc package. Currently, PS is setup to download either an SA, Postures, or MySql C# db driver. These odbc drivers are specific to their DBMS as supplied by their respective vendor.

  So trying to use odbc via PS is not the same as a native C/S app that can use the built-in MS-Windows odbc "hub" to broker DBMS access. 

Regards ... Chris 

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 11 April 2024 14:04 PM UTC
Suggestion:

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
  1. Helpful
Vijay Kumar
  1. Vijay Kumar
  2. Thursday, 11 April 2024 16:19 PM UTC
Great ! Thank you !
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 11 April 2024 16:47 PM UTC
You are most welcome!
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.