heres the situation, i have a windows 2008 enterprise server (brand new) so far the only thing installed on it out of the box is SQL Anywhere 9.0.2 and Mysql 5.1 its all setup and working i have transferred a database to the server and set it up as a service, however i cannot get a local or remote connection to the database to view tables, stored procs etc.
i have setup the windows Firewall to allow traffic into and out of the server on any port for that service but so far nothing has worked. According to Sybase's website 9.0.2 is supported on windows 2008, netstat shows no open connections except my RDP session.
I can however connect remotely and locally to the Mysql database.
am i doing something wrong?
Best Answer
The local connections use shared memory and so won't be affected by the firewall. Which application have you tried to connect with? I'd be interested in your connection string from the same machine-connection. Usually I use the uid, pwd, eng, and dbf parameters and they are enough to make a connection.