Print Thread
Can't Connect Oracle Session
#693 07/18/00 12:12 AM
Joined: Jul 2000
Posts: 12
Atlanta, GA USA
D
d4jaj1 Offline OP
Member
OP Offline
Member
D
Joined: Jul 2000
Posts: 12
Atlanta, GA USA
Hello,

I'm new to DOA (and Oracle for that matter), so this may seem like a stupid question but.... For some reason, I'm having a really hard time setting the Connected property of the OracleSession component to True at Design-Time. My first attempts all ended with Access Violations on ORA805 (or something like that). After I re-boot my computer, I no longer received the access violation, but I get an error stating my username and password is invalid. I KNOW the UserName & password are correct because when I enter the same values in a BDE Database component AND the SQL-Net application and everything works fine. So next, I attempted to set the active property at runtime by using the TOracleLogon's execute function. Entering the same values here allows me to successfully open the database at runtime. So, is there some sort of limitation to opening the DB in design? My configuration is below:

D5 Enterprise (SP1)
DOA 3.3.3 - Trial
Oracle 8.05 DB and Client

------------------
----------
Jay


----------
Jay
Re: Can't Connect Oracle Session
#694 07/18/00 08:03 PM
Joined: Sep 1999
Posts: 27
Germany
K
Member
Offline
Member
K
Joined: Sep 1999
Posts: 27
Germany
Hello Jay,

are you sure, you've entered the password/username in the right properties in the object inspector? The sequence in objectinspector is changed as in the standard logon-dialog.

Oliver

------------------
Oliver Kaesmann


Oliver Kaesmann
Re: Can't Connect Oracle Session
#695 07/20/00 03:12 AM
Joined: Jul 2000
Posts: 12
Atlanta, GA USA
D
d4jaj1 Offline OP
Member
OP Offline
Member
D
Joined: Jul 2000
Posts: 12
Atlanta, GA USA
Well, that must have been it, though I was sure I was entering them correctly. I t works fine now and I feel like an idiot now. Sorry to waste your time.


----------
Jay
Re: Can't Connect Oracle Session
#696 07/20/00 04:02 PM
Joined: Sep 1999
Posts: 27
Germany
K
Member
Offline
Member
K
Joined: Sep 1999
Posts: 27
Germany
You need not to feel like an idiot. What do you think why I knew this problem ....

------------------
Oliver Kaesmann


Oliver Kaesmann

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.054s Queries: 13 (0.021s) Memory: 2.5060 MB (Peak: 3.0393 MB) Data Comp: Off Server Time: 2024-04-27 11:04:09 UTC
Valid HTML 5 and Valid CSS