topic undefined in Report Server

undefined

Jmcast — Wed, 20 Nov 2024 03:02:02 GMT

error de conectividad: [microsoft][odbc sql server driver][sql server]sintaxis incorrecta cerca de '55555'.

Re: undefined

Sahir_Maharaj — Wed, 20 Nov 2024 13:35:31 GMT

Hello Jmcast,

Can you please try the following suggestions to troubleshoot:

Can you verify that numeric values like 55555 are not enclosed in single quotes (e.g., '55555'), as SQL Server treats values in single quotes as strings.
If the query is dynamically generated (e.g., through a script or Power BI), ensure that parameters are properly formatted.
I've found that sometimes, the issue arises due to driver configurations. Ensure the ODBC driver is properly set up and supports the SQL Server version.

If you can share the query or a snippet of the code generating the error, I can help pinpoint the exact issue.

Hope this helps.

Re: undefined

Anonymous — Thu, 21 Nov 2024 02:59:28 GMT

Hi, Jmcast

When we connect to SQL Server, we really need to enter the correct query statement. If you encounter an error, it's usually because the query statement is syntactically incorrect.

I checked my sql query again and I found the problem:

The way to check if your SQL statement is correct is simple, you just need to send your SQL to the AI and it will automatically correct the error for you. You can then complete the link by placing the new query statement in the dialog box.

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.