Q: connectstring for db multiconnect to Informix database (SAP R/3 Windows NT)
Posted in 1998
Topics: Security, Permissions & Auditing, Networking & sqlhosts Configuration
Hello, we want to use the multiconnect feature in SAP R/3 4.0B, OS Windows NT. To do this we have to create an entry for the external database system with transaction SM30 into the table DBCON with the function MAINTAIN. There are 5 columns to maintain: Name of connection = can be choosen free, e.g. INFODB DBS = in our case INF for Informix Database user name = selfexplaining, e.g. infouser Database password = dto., e.g. infopass Connection information = this is what we want to know ! How must the entry in the field "Connection information" be build ? It seems that it has to be a mix of the name of the Informix database server process name (e.g. infdb1), the hostname (e.g. infhost) and the protocol type (e.g. onsoctcp). But how is this token built correctly ? After that we would use the connection with the statement SET CONNECTION 'INFODB' in our ABAP/4 code. Any suggestions are welcome ! Regards, Lutz --- Lutz Marten, Lutz.Marten@mail.uni-wuerzburg.de, Germany