[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:Fri May 30 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:5118
Total number of notes:28246

5007.0. "ORA-03114 connecting to Rdb using Developer/2000" by NOMAHS::SECRIST (Rdb WWS; [email protected]) Thu Feb 06 1997 16:25

    
    
    	Are there any tricks to configuring Developer/2000 under 16-bit
    	to work against Rdb ?  Although I've got the tools connecting
    	fine under Windows95 the customer can't get past ORA-03114
    	errors using 16-bit DOS/Windows.  He can always connect fine
    	using the ODBC test program or MS-Access, even when Dev2K is
    	complaining about something.  We started out with ORA-03121
    	errors but he was lacking the OCA.  We both pared down to
    	only having installed Forms, Reports, the GUI common files,
    	the installer, the 2.10.11 ODBC driver, OCA, the required
    	support files, SQL*Net client, the system support files, and
    	tools utilities.  Even after installing the OCA the 03121
    	still happened until I had him remove and reinstall everything
    	in the list above.  Next we had to get past an insufficient
    	memory error on his machine... but now I have nothing left
    	to frob and he is still down.  Any ideas ?
    
    	Regards,
    	rcs
T.RTitleUserPersonal
Name		DateLines
5007.1Questions, questionsukvms3.uk.oracle.com::PJACKSONOracle UK Rdb SupportFri Feb 07 1997 05:365
    What network transport are you trying to use? Are you trying to use
    ODBC, or are you field testing native connect? If you are using ODBC,
    does the test program work?
    
    Peter
5007.2As Peter said questions, questionsCHSR38::ROHRThe Packers did it!Fri Feb 07 1997 06:3425
    This is from note 19791.1
    
    Error:  ORA 3114
    Text:   not connected to ORACLE
    -------------------------------------------------------------------------------
    Cause:  A call to Oracle was attempted when no connection was 
            established. Usually this happens because a user-written 
            program has not logged on. It may also happen if communication
            trouble causes a disconnection.
    Action: Try again. If the message recurs and the program is
    user-written,
            check the program. 
    
    Explanation:
            This error basically means 'I do not appear to be talking to an
            Oracle Server'.
    
    What does Rdb on the server say? Does it  connect or try to connect at all?
    Or is there not even a talk between the PC and the server?
    
    Have you loaded the Oracle 7 tables in the Rdb database? See in the D2k
    directory for the document explaining this (rdbinfo.pdf, amybe also in
    the OCA directory).
    
    /Regina
5007.3ODBC and TCP/IP are cool -- any ideas ?NOMAHS::SECRISTRdb WWS; [email protected]Fri Feb 07 1997 15:5817
    
    Customer is using ODBC and TCP/IP and the ODBC test program, etal.
    work fine.  I went through the complete install in advance on
    my W95 system and then made sure he did the same steps, although
    he is using DOS/Windows 3.1.  I successfully connect and he does
    not (but he can turn right around and use the ODBC test program).
    
    Although UBT dies with a WSANOTCONNECT error which results in the
    need to reboot, Reports should still connect even though the
    database tables from the script are not loaded yet (for example,
    on Windows95 I get "REP-1098, Error reading PRODUCT_USER_PROFILE
    or SYSTEM_PRODUCT_PROFILE data" if I connect to a database without
    those tables... but I still connect).
    
    Regards,
    rcs
5007.4You should also try th ODBC notes fileCHSR38::ROHRThe Packers did it!Mon Feb 10 1997 03:508
    Does logging on the PC give any more clues? 
    
    Also, you might want to put this note into the ODBC notes file. I am
    not sure Sue and Simon and Joe and all the other fine people who
    help out with ODBC and SQL Services are reading regularly in this notes
    conference.
                                   
    /Regina
5007.5client log neededSQLSRV::MAVRISSue Mavris - [email protected]Mon Feb 10 1997 10:095
We're here (some of us anyway).  Regina is right.  For us to get anywhere 
with this, we're going to have to turn on client logging and see what that 
tells us.

Sue
5007.6Would you believe...NOMAHS::SECRISTRdb WWS; [email protected]Tue Feb 11 1997 16:178
    
    	The rdbodbc.ini wasn't in the C:\WINDOWS directory.  Apparently
    	ODBC Test, MS-Acces, etal. can live without this, but Developer
    	2000 products cannot ;-)
    
    	Regards,
    	rcs