Unable to connect - "Error: Code: -103 Msg: Invalid user ID or password"

[joe-gibbs]

Node: Node.js 10.23.2 (ia32)
System: Windows 10 Pro 64-bit
SQL Anywhere: 17.0.10.5963 32-bit

With the following connection code

const connParams = {
        UserId: "dba",
        Password: "sql",
        dsn: "abc"
}

conn.connect(
    connParams,
    (error: any) => {
        console.log(error);
    }
);

I get this error: [Error: Code: -103 Msg: Invalid user ID or password].

However, when I run dbisql -c "userid=dba;password=sql;dsn=abc", it works perfectly, no issues.

I've tried the following:

• Switching to 32-bit Node from 64-bit and vice versa
• Using "userid=dba;password=sql;dsn=abc" directly instead of the params object
• Running as an administrator or as a regular user

[DanCummins-SAP]

Hi Joe,
I opened issue number 266170 and we plan to look into it.
https://sqlanywhere-forum.sap.com/ also hosts an active SQLA community.
Dan