undefined

[Jmcast]

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

[Anonymous · Accepted solution]

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.

[Sahir_Maharaj]

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.