I just installed version 11.5.1 of Sybase on an HPUNIX system version 10.2. I'm a database administrator for a Microsoft SQL Server 7.0 database so I 'should' be very familar with various aspects of Sybase.
However, at this point I don't know where to begin. Sybase was installed to the following directory:
Would it be best to reinstall Sybase to the root directory? I say this because I keep geting an error related to a variable which is not registered when I try to run the isql utility. I also get an error that says the isql utility couldn't be found.
If it doesn't really matter what directory Sybase is at, what do I need to do to start the server and what else do I need to do in terms of setup? To answer this question, I'll need specifics as to what utility or application issues the command...
The end goal:
I'm trying to simulate communication (or make a prototype) between a Microsoft SQL Server 7.0 database on NT 4.0 and the Sybase database on HPUNIX. Once I'm sure all necessary services are running for the Sybase database, I want to create the Sybase database, then create a few simple tables and a stored procedure. Once these are created, I will call the stored procedure on the Sybase database from the NT 4.0 system.
I'll increase points as necessary if needed.