Hi,

I have a .NET web service built with PB 2017 R3 that fails to connect to an ASE 16 database.

Web server: Windows Server 2019 / IIS 10 / ASE 15.7 DB client

DB server: ASE 16

Webserver is set up with:
- PB 2017 R3 runtime files (32 and 64 bit) and .NET runtime files. All three packages are created with PB runtime packager.
- The PBDotnet4AppPool is set up with .NET CLR version v4.0.30319, Classic mode, 32-bit apps enabled.

The webserver was booted after the install.

The message returned when the web service calls sqlca.connect is 4002: Login failed

Auditing on the db server shows that password is incorrect (network password sybase encryption, 4067.14.1), I have also tried without encryption, same result.

To verify correct setup of sqlca I put all settings into a logfile before connecting (servername, database, logid, logpass and dbparm). 

The logfile looks like this:

2024-10-24 15:31:13 Connecting to ProsaTst/prosa_test LogId: ims_interface_user/****** DBMS: ASE Adaptive Server Enterprise DBParm: Release='15',AppName = 'IMS interface'
2024-10-24 15:31:13 4002: Login failed.

If I connect with InteractiveSQL from the webserver with exact same credentials (cut and paste form the logfile) it connects successfully.

I also tried to install the PB 2017 R3 IDE on the webserver, and connected to the same database from the IDE with the exact same credentials (cut and paste form the logfile) and it connects successfully.

I can't figure out why the webservice db connect fails. Does anybody have a clue?