New Posts New Posts RSS Feed - Unable to connect to database/api?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Unable to connect to database/api?

 Post Reply Post Reply
Author
mfriend View Drop Down
Groupie
Groupie


Joined: 19-November-2017
Location: Nebraska, USA
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote mfriend Quote  Post ReplyReply Direct Link To This Post Topic: Unable to connect to database/api?
    Posted: 19-November-2017 at 2:15pm
Hi Support:

I'm running a trial version  of FormsTool trying to decide whether to buy it.

When I try to run a search I get the following error:

http://dinosaurfan.com/search_database.PNG



"Error Executing Search.... failed to connect to database API-001: Operation Failed."   I tried entering the username/password in many different ways with no luck...
Back to Top
administrator View Drop Down
Admin Group
Admin Group

Stefan Mueller

Joined: 25-January-2003
Location: New Zealand
Points: 1009
Post Options Post Options   Thanks (0) Thanks(0)   Quote administrator Quote  Post ReplyReply Direct Link To This Post Posted: 20-November-2017 at 6:19am
Dear Matthew,

Database connection strings are optional and not required, but especially in cases where you load large modules they do speed things up a bit (less pl/sql code to invalidate). EzConnect strings for database connections should work without problems as long as you use Forms 10gR2 and later .. and as long as you run the tool from a directory that has no parentheses "()" in the path (installing the tool in C:\Program Files (x86)\ will not work due to an Oracle Database bug!). I had no problem with connecting with EzConnect on my computer. Does your database connection work inside Oracle Forms Builder?

Regards, 
Stefan
Back to Top
mfriend View Drop Down
Groupie
Groupie


Joined: 19-November-2017
Location: Nebraska, USA
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote mfriend Quote  Post ReplyReply Direct Link To This Post Posted: 20-November-2017 at 6:30am
Hi Stefan:

I got it working last night.  So far I'm loving FormsTool....

Thanks,
Matthew
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.01
Copyright ©2001-2014 Web Wiz Ltd.