[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::rdb_60

Title:Oracle Rdb - Still a strategic database for DEC on Alpha AXP!
Notice:RDB_60 is archived, please use RDB_70..
Moderator:NOVA::SMITHISON
Created:Fri Mar 18 1994
Last Modified:Thu May 29 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:5118
Total number of notes:28246

5059.0. "web agent and remote db server" by M5::PSOEHL (The area is secured, Ripley!!!) Fri Feb 21 1997 13:01

    I have a question about the general sequence of events when using the
    web  agent on a node and attempting to access a database on another
    node and then a more specific question:
    
    
    Nodea has the web agent and the sql services api installed.  It has a 
    config entry for a database on nodeb. Nodeb has Rdb v7.0 installed, 
    SQL/Services 7.0 installed and a service defined for the given database
    that I  wish to access.  Does the web agent on nodea send a request via
    sql/services to nodeb?  What I read in the documentation is that nodeb
    does not need to have the web agent installed.  Am I right or way off
    base?
    
    A more specific question: 
    
    I've got an NT 4.0 Workstation Intel box that I've installed the web
    agent on.   I've installed the SQS Api from SQLSRV$NTINT directory on
    it.  I've got the  http://hostname/cgi-bin/rdbweb.exe/config  working . 
    I can add config entries.  I can use MS Access to attach to a given 
    service that I've got defined in my config entry.  I can  run sqs mgr
    on my  windows and see the service.  I can attach to the db using the 
    sqlsrv$dynamic example code on the remote node, so it appears that the
    db  is accessible via sqlservices.  I've run rdbweb_api and rdbweb_gen 
    against the db (apparently successfully; the functions and procedures
    seem to be there). 
    
    When I click the "try this entry" link on the config page for this
    entry I get the  following:
    
    -------------- 
    
    Rdb returned an error
    
    -SQL-F-SYNTAX_ERR, Syntax error
    
    sts [16] from exe_statement is 1 call  ()
    ----------------
    
    Any ideas?
    
    TIA
T.RTitleUserPersonal
Name		DateLines
5059.1NOVA::DDIAMONDDave Diamond, Oracle RdbFri Feb 21 1997 13:197
when you configured the service, did you give a default procedure name?

the 'try this entry' will try and use the default procedure.

please mail and post your reply.

dd
5059.2mf_personnelStartupM5::PSOEHLThe area is secured, Ripley!!!Fri Feb 21 1997 13:2510
    In the config entry I had 
    
    startup	mf_personnelStartup
    
    Which I see when do a 
    sql> show procedure mf_personnelStartup
    
    
    	Is this what you mean?
5059.3M5::PSOEHLThe area is secured, Ripley!!!Fri Feb 21 1997 13:416
    I changed the entry to 
    
    procedure mf_personnelStartup
    
    still get the same error
5059.4changed name of config entry, now worksM5::PSOEHLThe area is secured, Ripley!!!Sat Feb 22 1997 11:0716
    Very interesting.  I changed the name of the config entry; it was
    the same as the host name.  I changed it from hostname to hostnamecfg.
    
    It now works!
    
    I don't believe I saw anything in the doc saying the config entry name
    can't be the same as the hostname.  Maybe I missed it. 
    
    Do you think I just ran across a strange alignment of the 
    planets?
    
    Thanks,
    
    pnsoehl