Question Re: Error: Code: -2004 Msg: Can't initialize DBCAPI in Technology Q&A

Error: Code: -2004 Msg: Can't initialize DBCAPI

Former Member — Sun, 09 Jul 2017 23:32:05 GMT

I am using node js (sails) and SQL Anywhere 16 for development. After I install node Sql Anywhere driver and follow all step to set up SQL Anywhere environment. (I also install the client software in my mac).it always return Error: Code: -2004 Msg: Can't initialize DBCAPI. However, i can run the dbping command for ping the other server database and return successful . What i missed and how can fix it? Thank you

Re: Error: Code: -2004 Msg: Can't initialize DBCAPI

VolkerBarth — Mon, 10 Jul 2017 03:18:12 GMT

Can't tell on that error, but is there a particular reason you are not using SQL Anywhere 17 which has builtin support for node.js?

Re: Error: Code: -2004 Msg: Can't initialize DBCAPI

former_SQLA_member1694893 — Mon, 10 Jul 2017 07:34:57 GMT

Have you run sa_config.sh? It seems that you library path is not configured. Please, run: sudo /SQLANYWHEREDIR/bin64/sa_config.sh before trying to connect to SqlAnywhere

Re: Error: Code: -2004 Msg: Can't initialize DBCAPI

graeme_perrow — Mon, 10 Jul 2017 08:19:38 GMT

Running "sudo .../sa_config.sh" will create a shell, run sudo in that shell, run the script in that shell, and then drop the shell, which means it will have no effect at all. You want to run . <SQLANYWHEREDIR>/bin64/sa_config.sh (note the "dot space") in the same shell as your application.