I have installed SQL Anywhere 17 on my Raspberry PI.
I have issued the command dbsrv17 -ud mysqlDB01.db and can see the message that the server is started
Next, I am using SQL Central on my laptop to connect to this DB. I have provided the below values.
Authentication: Database UserID: murali password: sql123 Action: connect to running database on another computer Host: 192.168.8.100 Port: 2638 Server Name : mysqlDB01 Database name: mysqlDB01
My Ping to the Host works. However, when I test the DB connection, it fails. I ran an ifconfig command on RaspberryPI and got two values lo inet address=127.0.0.1 wlan0 inet address=192.168.8.100
Below is the error I get in SQL Central
Fri Jun 10 2016 16:04:19 16:04:19 Attempting to connect using: UID=murali;PWD=********;DBN=mysqlDB01;ServerName=mysqlDB01;CON=SQL_DBC_61e47f37f0;LOG=C:\Users\I305544\AppData\Local\Temp\testcon9091539794935435267.tmp;ASTART=NO;Host=192.168.8.100:2638 16:04:19 Attempting to connect to a running server... 16:04:19 Attempting TCPIP connection (no sasrv.ini cached address) 16:04:19 Looking for server with name mysqldb01 16:04:19 Trying to find server at address 192.168.8.100:2638 16:04:19 Found server, verifying server name 16:04:19 A HOST value was specified, skipping LDAP check 16:04:19 Failed to connect over TCPIP 16:04:19 Removing failed address from sasrv.ini cache 16:04:19 Not attempting to autostart server 16:04:19 Cannot connect to server
I also noticed that the ping also fails at times. All my devices are on the same Internet connection supplied by my wifi dongle. So they are all on the same network.
Sorry, I couldn't work out hoe to reply rather than answer - this may or may not be an answer.
I don't know much about Pi's but in a Windows environment one of the first things I'd be looking at is the firewall. Is there a firewall on the Pi that needs to allow access on port 2638?
answered 10 Jun '16, 06:26