cancel
Showing results for 
Search instead for 
Did you mean: 

How to Connect to Sql Anywhere 12 Remotely

Former Member
0 Kudos

I'm pretty new to Database Management/Networking and I've been tasked with remotely hooking into a Sql Anywhere 12 database so that my app can interact with another app's data.

The DBA of the other app has opened a public port for me and has given me the IP and port to connect to. I am working on a Mac and have tried to install the ODBC driver for Sql Anywhere. I really have no idea what I'm doing and hoped that someone here could help me to get this setup.

My questions basically revolve around, at an abstract level, how does connecting to this database over a port work? Do I need to setup an ODBC client on my local machine that talks to the database via the open port? If so, how do I do that on a mac.

Second, my app is built on Node.js and I see that there is a module for working with databases over ODBC https://github.com/wankdanker/node-odbc If this is available, do I still need to set up a Sybase Sql Anywhere client on my local machine? Or does this node module replace it?

As you can tell, I'm very lost. I'm totally on the application development side of things and don't do much with hooking into databases, etc... Any help you can provide would be much appreciated!

Message was edited by: Nick Elson

Accepted Solutions (1)

Accepted Solutions (1)

former_member182948
Active Participant
0 Kudos

Hi Ryan,

If you want to use an ODBC on a Mac, you will need setup of the ODBC Driver.

Perhaps you will be able to use an ODBC data source from node-odbc.

You can see the following manuals for ODBC on a Mac.

"Adding the SQL Anywhere ODBC driver (Mac OS x)"

http://dcx.sap.com/index.html#1201/en/dbadmin/add-odbc-driver-mac.html

"Creating an ODBC data source (Mac OS X)"

http://dcx.sap.com/index.html#1201/en/dbadmin/connect-s-3731160.html

Thanks

Answers (0)