topic connect to Informix from report builder failed in Report Server

connect to Informix from report builder failed

rodg — Mon, 16 Dec 2024 19:09:17 GMT

Hi,

I am trying to connect to an Informix database using Report Builder, but I’m encountering an issue. Here’s what I have done so far:

In Report Builder:

Does anyone know how to resolve this?

Anonymous — Tue, 17 Dec 2024 07:04:31 GMT

First, add an Informix database connection correctly in ODBC as shown in the following image:

Connect to it using ODBC in report builder:

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rodg — Tue, 17 Dec 2024 12:22:30 GMT

Hi Jianpeng Li,

The connection to the database is now active in Report Builder.

However, I’m facing an issue when trying to use a stored procedure (on Informix) with parameters.

Despite this, I keep encountering the following error:

=> ERROR [42000] [Informix][Informix ODBC Driver][Informix]A syntax error has occurred.

I’ve set the LoggingTraceLevel in Report Builder to "Verbose," but unfortunately, the log file doesn’t provide any additional insights.

Do you have ideas on what might be causing this error?

Could it be related to syntax, parameter handling, or some driver issue?

Note: My OS is in Dutch, so the Report Builder UI is also in Dutch—apologies if any screenshots include Dutch text.

Thanks in advance for your help!

Anonymous — Wed, 18 Dec 2024 09:32:53 GMT

Try to paste the query into Text to run, ODBC connector only supports? To occupy a placeholder for a parameter in Power BI Report Builder:

The order of the parameter pages will determine the ? location.

In stored procedures, we usually can't define one? as a query variable, so you're getting an error. Try writing a query inside the Report builder.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rodg — Wed, 18 Dec 2024 10:41:24 GMT

Hi Jianpeng Li

I have a working version.

Thanks !

Ronny