sqlanywhere / node-sqlanywhere

SAP SQL Anywhere Database Client for Node
Apache License 2.0
38 stars 36 forks source link

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

Open joe-gibbs opened 3 years ago

joe-gibbs commented 3 years ago

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:

DanCummins-SAP commented 3 years ago

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