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

'Unable to start, server not found' Problems using ASA

Hello all.

I have recently taken a new application which uses Sybase ASA database. I have very minimal experience of SQL databases, so I have a very steep learning curve.

I have installed the application on a Windows XP machine. When I go to a remote PC, another Windows XP box, to install the application I need to be able to connect to the database on Machine 1. I have the ASA server running on Machine 1, but I cannot connect to it from Machine 2. When I start the server it loads up great using TCPIP on port 2638. I get the following error:
SQLSTATE=IM003
Specified driver could not be loaded due to system error 126 (Adaptive Server Anywhere 8)

When I try to log on to the database server from Machine 2 using dbisqlc.exe I get the error: Database server not found

Under the network tab I have specified the IP address of Machine 1 using 'host=', but still nothing.

I have switched off the firewall on both Windows XP machine, by switching off the 'Windows Firewall/Internet Conncetion Sharing' service in the Services.

I have also switched off the anti virus on both machines, still nothing.

I have also tried installing the database server on a WIndows 2000 box, but I still cannot connect to the database.

I would appreciate any help. Please understand I really don't have much experience of ASA. I am hoping to take a Sybase course within the next few weeks.

Many Thanks


0
intralia
Asked:
intralia
  • 2
1 Solution
 
Joe WoodhousePrincipal ConsultantCommented:
A typical network address for ASA might look something like

host=nnn.nnn.nnn.nnn;port=nnnn

If you don't specify the port you get the default port 2638, which might already be in use.

I'm a bit concerned by the driver error though. Try reinstalling?
0
 
Joe WoodhousePrincipal ConsultantCommented:
... Don't agree I should get points for this one, it isn't clear the problem was fixed.

Suggest instead Delete, No Refund.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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