NeXTcommunity

Everything => Software => Topic started by: ptek on Sep 13, 2025, 01:14 PM

Title: Sybase SQL Server 4.0.1 on NS3.3
Post by: ptek on Sep 13, 2025, 01:14 PM
  I had trouble installing Sybase_SQL_Server 4.0.1 on NS3.3 with Previous 0.5 as the menu would not show up when I hit F12. How I managed to over come that was by copying both Sybase_SQL_Server-limited.pkg to the HDD. Copying Sybase_SQL_Server-limited.tar.Z.n (Where n is 1 or 2 depending on the disk) and then using the following:

# cat Sybase_SQL_Server-limited.tar.Z.1 Sybase_SQL_Server-limited.tar.Z.2 > Sybase_SQL_Server-limited.tar.Z

  I then copied Sybase_SQL_Server-limited.tar.Z back to one of the packages and removed the Sybase_SQL_Server-limited.tar.Z.n file that was in it.
  After that I renamed the .pkg file to remove the number at the end either one or two. I was then able to complete the installation as root.

  Still working through installing it and following through the tutorials and using dbkit in Interface Builder.

EDIT: (26-Sep-2025)
How to install pubsdemo in NS3.3 in Previous

Login as root and install Sybase, because my user account me is in the wheel group I just su - in the terminal.

su -
/NextAdmin/Installer.app/Installer &

Leave this terminal open.

Then click on the package on the disk 1 floppy and install it.

After Sybase server is installed, in the documentation GettingStarted.wn it says to create a password for the Sybase account so go back to the terminal where we are root and do the following:

passwd sybase

After you have created a password for user sybase, log out as user root then create a user sybase terminal

su - sybase
source scripts/SetVars
startserver

Install the example database pubs by tying in the user sybase terminal.

Apps/Administrator &

Click on "Install PUBS Database"
Sybase-InstallPubs.PNG

Copy the PubsDemo database from /NextDeveloper/Examples/DatabaseKit/PubsDemo/SybaseDemo.dbmodela to
/LocalLibrary/Databases/ (If this folder does not exist, create it) folder so that other users on the system developing apps with DBModeler and InterfaceBuilder can access the database.
Sybase-LocalLibrary-Databases.PNG
Title: Re: Sybase SQL Server 4.0.1 on NS3.3
Post by: Rhetorica on Sep 13, 2025, 03:37 PM
I'm glad its screwed-up installer is no longer a hard obstacle.

Remember to check out this (https://fsck.technology/software/NeXT/NeXTSTEP%20Applications/BeMA%20Sybase%20Lim%20Server%20NeXTSTEP/) (iirc it's disk 3 of the original four-disk set.)

Since you're (presumably) still slumming it with Previous 0.5 on Windows XP, you'll want the version I stripped of the DiskCopyII.app header and re-uploaded, here: http://index.rhetori.ca/cdrom/fixed-floppies/Sybase%204.1/BeMA_Sybase_lim_server.fixed.diskimage

Based on the name I think it's just a deployment image for server replication. It could possibly be a dependency for other products that needed a small SQL server, or some sort of cheaper trial option, but that would make the decision to ship them together very strange.
Title: Re: Sybase SQL Server 4.0.1 on NS3.3
Post by: Protocol 7 on Sep 13, 2025, 04:16 PM
Quote from: Rhetorica on Sep 13, 2025, 03:37 PMRemember to check out this (https://fsck.technology/software/NeXT/NeXTSTEP%20Applications/BeMA%20Sybase%20Lim%20Server%20NeXTSTEP/) (iirc it's disk 3 of the original four-disk set.)
This is just another copy of Disk #1. The last two disks were an optional diagnostic server. These weren't supplied to NeXT owners who bought the 2.0 upgrade which included the updated copies of Sybase, Allegro CL and Mathematica.

The installation guide on the first disk references 4 disks and mentions that the second pair are the diagnostic server. The printed copy attached below that was included with the bundle changes the disk count to 2 and omits the info about the diagnostic server (taken from here (https://www.worthpoint.com/worthopedia/next-computer-software-bundle-sybase-4772724585).)
Title: Re: Sybase SQL Server 4.0.1 on NS3.3
Post by: Rhetorica on Sep 13, 2025, 04:49 PM
The mystery is solved! Thanks, @Protocol 7!
Title: Re: Sybase SQL Server 4.0.1 on NS3.3
Post by: ptek on Sep 14, 2025, 05:04 AM
Yes Rhetorica, I used the version from your site as it would have taken me longer to remove the header bytes from the disk image.

I've made progress with Sybase managed to get it installed up and running and install the test example db pubs. I also managed to open the example db pubs with DBModeler. Now to try and get it working with Interface Builder.

EDIT: How do I add attachments? I wanted to upload a screenshot?
Title: Re: Sybase SQL Server 4.0.1 on NS3.3
Post by: Rhetorica on Sep 14, 2025, 02:51 PM
Okay, okay, I'll stop mother-henning over you. :)

Quote from: ptek on Sep 14, 2025, 05:04 AMEDIT: How do I add attachments? I wanted to upload a screenshot?

Hit the "Reply" button rather than using the Quick Reply form at the bottom of the page. (This is an obnoxious SMFism that has been with us since the start.)
Title: Re: Sybase SQL Server 4.0.1 on NS3.3
Post by: ptek on Sep 15, 2025, 02:48 AM
QuoteOkay, okay, I'll stop mother-henning over you. :)

QuoteEDIT: How do I add attachments? I wanted to upload a screenshot?

Hit the "Reply" button rather than using the Quick Reply form at the bottom of the page. (This is an obnoxious SMFism that has been with us since the start.)
My web browser must be too old as I can't find the upload button :/ I've tried hitting the Reply button and Quote button :/
Title: Re: Sybase SQL Server 4.0.1 on NS3.3
Post by: ptek on Sep 16, 2025, 10:55 AM
Here is the screenshot I wanted to upload a couple of days ago showing the Sybase pubs example database in DBModeler. (Ignore the date :D)

Sybase-DBModeler01.PNG
Title: Re: Sybase SQL Server 4.0.1 on NS3.3
Post by: ptek on Sep 16, 2025, 10:29 PM
  Sybase needs to be up and running while compiling the database kit example pubsdemo or else ProjectBuilder will hang and crash the machine and you have to reset it.

  When you are using Interface Builder on NS3.3 and if the DBModeler does not appear or load click on Open Palette on Interface Builder and load from /NextDeveloper/Palettes/.

  EDIT: These are the proper steps if DBModeler do not appear in Interface Builder.

IB -> Tools -> Palettes -> Open
and load in the file from /NextDeveloper/Palettes/DatabaseKit.palette
Title: Re: Sybase SQL Server 4.0.1 on NS3.3
Post by: Rhetorica on Sep 17, 2025, 01:14 AM
Quote from: ptek on Sep 16, 2025, 10:29 PMSybase needs to be up and running while compiling the database kit example pubsdemo or else ProjectBuilder will hang and crash the machine and you have to reset it.
That is so weird. I've never heard of a compile-time dependency like it before.
Title: Re: Sybase SQL Server 4.0.1 on NS3.3
Post by: ptek on Sep 17, 2025, 12:53 PM
Quote
QuoteSybase needs to be up and running while compiling the database kit example pubsdemo or else ProjectBuilder will hang and crash the machine and you have to reset it.
That is so weird. I've never heard of a compile-time dependency like it before.
Well we will wait for someone else to confirm as well.
Title: Re: Sybase SQL Server 4.0.1 on NS3.3
Post by: ptek on Sep 18, 2025, 03:54 AM
I was wondering why the Sybase database was not showing up in Interface Builder. Here is why from the following documentation. https://www.nextop.de/NeXTstep_3.3_Developer_Documentation/Concepts/DatabaseKit/03_Models.htmld/index.html (https://www.nextop.de/NeXTstep_3.3_Developer_Documentation/Concepts/DatabaseKit/03_Models.htmld/index.html)

QuoteChapter 3 - Database Models

Model Files
    There are two types of model files:

        Archive models are in a binary format and have the extension ".dbmodel".
        ASCII models are in ASCII and have the extension ".dbmodela".

    Only archive models can be used in your application--ASCII models must be converted to archive format before they can be used.  However, the conversion from ASCII to archive is done automatically when you compile your application.  (As described in the next chapter, ASCII models can be used in Interface Builder.)

You can store your model files in the Databases subdirectory of a Library directory, or you can copy them into your application's project directory (this is described in a later chapter).  When the Database Kit searches for a model, it does so by the model's name--in other words without reference to the file's path or extension.  Models in the project directory precede those in the library directories.  The search through the libraries is done in the usual order:  ~/Library, /LocalLibrary, /NextLibrary.

Example Models

Example model files (in archive format) can be found in the directory /NextDeveloper/Examples/DatabaseKit/Models.  The OracleDemo.dbmodel model uses the entities and properties defined by the Oracle adaptor; the SybaseDemo.dbmodel model uses the Sybase adaptor.

VirtualBox_NextSTEP 33_DBModeler-Setup.png
Sybase-DBModeler03.PNG

Two different emulators which are NOT talking to each other, the reason is I went to take a screenshot on the old Previous0.5 and it PrtScr just rebooted the NeXT emulated machine so I quickly redesigned the basic app in VirtualBox. It's an old buggy version of Previous  :'(

I'm getting better and improving with Sybase \o/ even though it's only basic stuff LOL.
Title: Re: Sybase SQL Server 4.0.1 on NS3.3
Post by: ptek on Sep 26, 2025, 03:46 AM
Added basic tutorial instructions in first post, knowing my previous attempts there is probably missing stages :D