Skip to Content
Former Member
Sep 28 at 12:36 PM

Sql anywhere -User DSN is not getting updated using windows script


screenshot-after-executing-the-script.jpgscript-snippet-sqlanywhere9.txtWe have a Power builder based product(Appeon Power Builder 21 – Pro – 32 bit). This product has a client DB hosted in SQL Anywhere 9. Both these components are deployed to windows server 2016 R2

Power builder UI makes use of ODBC to get connected to the SQL Anywhere 9. User DSN for this ODBC connection is set up by a windows script.

Recently we have done a POC to upgrade SQL Anywhere 9 to SAP SQL Anywhere 17. After this upgrade, User DSN set up via windows script stopped working.

We are able to set up ODBC manually. But it is not feasible since we have 500+ users which uses this ODC connection.

I have attached old windows odbc creation script(working version) and new odbc creation script(not working).

Only change in these scripts are the ODBC driver used for SAP SQL Anywhere 17.

We suspect that dbodbc17.dll(32 – bit) is not working with windows cmd script. We haven’t raised this ticket with windows since same windows script is able to create User DSN for SQL Anywhere 9 version.

We have attached issue replication screen shots and scripts. Please review and let us know about the fix.