Windows installation missing executable

[coreysj]

I have successfully installed SQLAnywhere on Windows without any issues, but this latest attempt it somehow failed. It did not show any errors installing, but when I try to connect to a database with the SQL Central utility it says there is no executable. Looking in the bin folder there is no dbeng17.exe file. When I try to reinstall the software scjview.exe crashes with the message SAPJVM_LoadLibrary_with_trace could not be located in java.dll. Another post on this forum suggested I needed to install the Microsoft Redistributable and I did but it did not resolve this. For context, SQLAnywhere 17 was the second program installed after Java on a clean Windows installation with latest updates, so there shouldn't be any conflicts. Would it work to copy over the missing dbeng17 from another windows installation?

[chris_keating]

If you are installing SQL Anywhere 17.0 SP1 PL10 Build 7254 or newer, you will need to install the Visual Studio Runtime compatible with Visual Studio 2015, 2017, 2019, and 2022. This is required by the SAP JRE and if missing, the install will report errors when attempting to start SQL Central to setup the plugins and the sample connection profile. It has no impact on other binaries such as dbeng17.

When you say you reinstalled, have you uninstalled completely the "broken" install and then installed the product again. It is very odd that installed missed dbeng17.exe - is there a dbsrv17.exe? What version and build did you attempt to install? SQL Anywhere has an independent SAP JVM in its binX\\jre180 directory. The other option is to attempt a repair of the install which will generally work with exe and dll files but less so with other files such as JAR files in %sqlany17%\\java.

Also note, a SQL patch is also a full install - you just need to supply the registration key (or will default to a Developer Edition) - if there is not an existing SQL Anywhere install. It acts as an update if there is an existing SQLA 17 install.

[coreysj]

Thank you for the response. I have installed all 12 of the visual c++ redistributable runtimes (from 2005 through 2022) using the all-in-one installer found here (https://www.techpowerup.com/download/visual-c-redistributable-runtime-package-all-in-one/). I have completely uninstalled and reinstalled the windows client from here (https://wiki.scn.sap.com/wiki/display/SQLANY/SAP+SQL+Anywhere+Database+Client+Download) but it does not install the executable dbeng17 or dbsrv17, and so in sql central it gives the error 08001 (executable cannot be found). I have a license key but I was not asked for it during the installation. Is there a different installer I should try to use?

[chris_keating]

Well that explains things. The SQL Anywhere client only install only installs client components. It does not install server components such as dbeng17 and dbsrv17. You should not install the client only install on the same environment where the full SQLA package will be installed.

What exactly are you doing in SQL Central? It should only be looking for dbeng17 if it is attempting to autostart a database server. With a client only install, you should be connecting to an existing running server (on a different machine).

If you have a license key for SQL Anywhere, I assume you are a S- user with access to the SAP Support portal and more specifically Software Downloads. From the Download Software page,

• select Support Packages & Patches
• select By Alphabetical Index (A-Z)
• select S
• select SYBASE SQL ANYWHERE
• select SYBASE SQL ANYWHERE 17.0
• set the platform download to WINDOWS ON X64 64BIT
• click the hyperlink above the latest build

The latest build is currently SQL Anywhere 17.0 SP01 PL13 Build 7432.

If you do not have access to the downloads sit, please contact your account rep or work with the SAP coordinator in your organization to add you as a support contact.

The file that is downloaded can be used to update an existing SQL Anywhere install ( NOT A CLIENT ONLY INSTALL ) or to do a complete install from scratch. Note this install can also be used to install the Developer Edition if no license key is provided. Make sure that you understand the permitted uses of the Developer Edition and ensure that it is not used in a production environment.