• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • Last Modified:

Failed to connect to Sybase IQ remotely

Hi,

I just built a new Sybase IQ database and was able to connect within the server.  However when I tried to make a connection from another computer.  I was failed to log in.  The error message was wrong user id and password, but I can use the same credential to log in if I connect within the server.  I have turned off the firewall, so it should have nothing to do with the firewall.

Do I need to enable some property of the database or add some permission to the user so as to enable remote log in?  Thanks.
0
thomaszhwang
Asked:
thomaszhwang
1 Solution
 
Joe WoodhousePrincipal ConsultantCommented:
You need to specify the connection details. Usually for IQ you'd create an ODBC data source on every machine you want to connect from. This uses the ODBC driver that would have shipped with your IQ. In that data source you'd specify the connection details of your IQ server, which generally just means IP hostname and an IP port. These obviously have to match how your server has been setup. :)

The Quick Start manual has a chapter on setting up an ODBC data source:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.help.iq.15.3/title.htm 
0
 
thomaszhwangAuthor Commented:
Thanks.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now