Sybase ADDICT

Sybase ASE (Adaptive Server Enterprise) can now be installed easily on Linux distribution running kernel 2.6.x.

So i tried to install ASE 15.0.3 ESD1 on my favorite Linux: Slackware 12.2. Why Slackware ? Because it rocks !! In my opinion, the best Linux distribution ever, and 64 bits release came out recently.

But this come with a little issue… Sybase ASE need PAM to be installed.

Otherwise it will not start. And guess what ? Slackware does not come with PAM. Well, the truth is you don’t really need the all PAM package to start ASE, you just really need the PAM libraries.

Install PAM libraries is easy:
- just download the PAM library sources at http://www.kernel.org/pub/linux/libs/pam/library/
- unzip and untar the file

and start compilation:

./configure
make
make install

Now you can start ASE on Slackware Linux ! You know what ? I’m happy now

Quickly find out the database’s tables having identity columns:

select object_name(id) as "tablename",name as "column_name"
from syscolumns where status =128
go

Enjoy