Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!tut.cis.ohio-state.edu!pt.cs.cmu.edu!speech2.cs.cmu.edu!jdravk
From: jdravk@speech2.cs.cmu.edu (Jeanette Dravk)
Newsgroups: comp.databases
Subject: connection problems with Sybase
Message-ID: <11516@pt.cs.cmu.edu>
Date: 4 Jan 91 18:35:02 GMT
Organization: Carnegie-Mellon University, CS/RI
Lines: 49

The following code gets me a SYBECONN error from dbopen().  [i.e. "Unable to
connect: SQL Server is unavailable or does not exist."]  It's worked
before at my previous job but the first time I try it here it dies a gruesome
death.

Any ideas are sincerely welcome.


jeanette-


----

DBPROCESS	*dbp;
LOGINREC	*login;

main()
{
.
.
.

sybase_login();
.
.
.
}

int sybase_login()
{
	if (dbinit() == FAIL)
		return 0;

	dberrhandle(err_handler);
	dbmsghandle(msg_handler);

	login = dblogin();
	DBSETLUSER(login, "foo");
	DBSETLPWD(login, "foobar");
	dbp = dbopen(login,NULL);

	return(1);
}

[Where DSQUERY has already been set].
-- 
#*#*#*#*#*#	Transient Creature of the Wide, Wild World	#*#*#*#*#*#*#*

   "Time is not linear to me, it is a nebulous web of existential freedom."