Hi, I've just installed SAP DB 7.4 on Mandrake 8.1 with iODBC.
When starting off I ran into a lot of errors and there seemed to be a lot of solutions to every error I encountered. However if you install all the applications correctly from the offset you will hopefully not encounter all these problems and can then enjoy using SAP DB without spending valuable time on solving all the nasty issues found in the mail archives. Firstly I use Mandrake 8.1 but I'm sure the method I've outlined here will apply to many other flavours of linux. Note I'm going to call our database DB1 and the datasource name SAPDSN1 Here's how I did it: -Installed Mandrake with all the options for Development included (might not all be necessary to everybody but if you got disk space rather do it now) -Install SAP-DB and SAP-Webtools using SDBINST ; SAP-DB throws me out after entering password for the newly created sap user during SDBINST but all you need to do is run SDBINST again. You will have to do the install in a shell as root (use su) -cd /root; emacs .bashrc; add LD_LIBRARY_PATH=/opt/sapdb/indep_prog/web/lib:$LD_LIBRARY_PATH; add export LD_LIBRARY_PATH -I rebooted after this (probably not necessary) -Login as sapdb -Open shell; cd /opt/sapdb/indep_prog/bin; ./x_server start -Open shell; su (enter your root password); cd /opt/sapdb/indep_prog/web/pgm; ./wahttp -Now open a browser and enter http://localhost:85/webdbm -Select new database -Enter a name for the database instance=DB1 -Enter localhost,sapdb,(sapdb password) -Go through all steps for creating DB - I'm not going to list that here (you can download the sapdbadmin_74.sim from SAP for a tutorial on this) -Get the latest ODBC driver ftp://ftp.sap.com/pub/sapdb/bin/patch/sapdb-odbc-linux-i386-7.3.0.34pre.tgz; This driver has included math and thread libraries - otherwise you will get __fpclassify etc errors later on. -Unpack this driver to /opt/sapdb/ODBC -Unpack the latest iODBC -./configure --prefix=/usr -make -make install -Now run iodbcadm-gtk -Add driver in /opt/sapdb/ODBC/lib (same for setup file) -Now add User DSN (call it SAPDSN1), select the newly created driver, add ServerDB:DB1,add ServerNode:localhost -Now open shell as sapdb and enter cd /opt/sapdb/indep_prog/bin; ./dbmcli -d DB1 -u dbm,dbm db_start; ./dbmcli -d DB1 -u dbm,dbm db_online -Now navigate to the iODBC install directory to samples; execute ./odbctest "DSN=SAPDSN1;UID=dba;PWD=dba" -If you get an SQL> prompt you have succeeded in setting up a SAP database using iODBC to connect I hope this helps whoever is installing SAP,iODBC on Linux - It looks as though there are too many people battling out there - I was one of them ! If you follow the steps correctly you should not get any errors. Thanks to Thomas K�tter of SAP for his valuable help on this matter. David Blake _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
