Delphi 10 - Cannot connect to database in Design Mode
Delphi 10 - Cannot connect to database in Design Mode
I haven't worked with Delphi since Delphi 3. So my working knowledge of the IDE in Delphi 10 is limited. Tasked with altering an existing application on a newly Delphi installed system, I've been unable to access the Stored Procedure code to be altered in the TOraStoredProc object. Database login fails with "TNS error" when entering Data Editor... Where does the Server pulldown get populated from. There is only one entry in this list. Shouldn't I see all entries from tnsnames.ora, which tnsnames.ora?
Delphi 2010
Devart Trial Edition 7.20.0.7
The problem is now worst. Upon starting Delphi this morning, I get the error message "Fatal error: failed to access critical program data" with the window title "Devart Database Developer Tool".
After Delphi opens, clicking the Devart "New Connection" icon gives "Failed to load database provider for Oracle".
Got any ideas? I think I re-installed Devart yesterday afternoon without first uninstalling. I will try uninstalling/installing.
Devart Trial Edition 7.20.0.7
The problem is now worst. Upon starting Delphi this morning, I get the error message "Fatal error: failed to access critical program data" with the window title "Devart Database Developer Tool".
After Delphi opens, clicking the Devart "New Connection" icon gives "Failed to load database provider for Oracle".
Got any ideas? I think I re-installed Devart yesterday afternoon without first uninstalling. I will try uninstalling/installing.
Nevermind on the "worst problem". I forgot to execute Delphi as administrator.
What do you mean by OraSession window?
I'm a little confused about the Design Mode connection. Just figured out I can establish a DB connection successfully in Direct mode under Tools / Devart Developer Tools / Oracle / Database / New Connection. (It continues to fail to connect using TNS, not sure what's up with that.) Anyway, with a connection established, why does it prompt to connect in the TOraStoredProc object accessing the Data Editor? Furthermore, is the Data Editor the place to edit the plsql code block in the control? That is what I'm really trying to accomplish.
1) Where's the place to edit the plsql code block in the TOraStoredProc control?
2) What does the Data Editor allow you to do in the TOraStoredProc control?
3) What populates the Server field in the TOraStoredProc Data Editor popup?
4) Why is Direct connect not available in the TOraStoredProc Data Editor popup?
5) Why doesn't the TOraStoredProc Data Editor use the existing DB connection already established?
Sorry for so many questions. Any guidance you can provide would be most helpful.
What do you mean by OraSession window?
I'm a little confused about the Design Mode connection. Just figured out I can establish a DB connection successfully in Direct mode under Tools / Devart Developer Tools / Oracle / Database / New Connection. (It continues to fail to connect using TNS, not sure what's up with that.) Anyway, with a connection established, why does it prompt to connect in the TOraStoredProc object accessing the Data Editor? Furthermore, is the Data Editor the place to edit the plsql code block in the control? That is what I'm really trying to accomplish.
1) Where's the place to edit the plsql code block in the TOraStoredProc control?
2) What does the Data Editor allow you to do in the TOraStoredProc control?
3) What populates the Server field in the TOraStoredProc Data Editor popup?
4) Why is Direct connect not available in the TOraStoredProc Data Editor popup?
5) Why doesn't the TOraStoredProc Data Editor use the existing DB connection already established?
Sorry for so many questions. Any guidance you can provide would be most helpful.
Hello,
To establish an OCI mode connection you need to have and installed Oracle Client software. If Oracle Client is installed, try connecting to the server using standard Oracle SQL*Plus utility. If you connect successfully, use the same connection settings (TnsName, Login, Password) for OraDeveloper Tools and TOraSession.
1) TOraStoredProc cannot be used to edit the DDL code of the stored procedure. You may use OraDeveloper Tools to edit stored procedures.
2) Data Editor of the TOraStoredProc component allows viewing (not editing) dataonly if the stored procedure has a CURSOR out parameter.
3) Field is filled only in case if TOraStoredProc returns CURSOR
4), 5) To use TOraStoredProc, you need a correctly configured TOraSession component. TOraStoredProc component cannot connect to the server by itself. You need to specify an existing TOraSession in the TOraStoredProc.Session property. You can choose the connections, configured in OraDeveloper Tools, in the Existing list of the TOraSession component.
To establish an OCI mode connection you need to have and installed Oracle Client software. If Oracle Client is installed, try connecting to the server using standard Oracle SQL*Plus utility. If you connect successfully, use the same connection settings (TnsName, Login, Password) for OraDeveloper Tools and TOraSession.
1) TOraStoredProc cannot be used to edit the DDL code of the stored procedure. You may use OraDeveloper Tools to edit stored procedures.
2) Data Editor of the TOraStoredProc component allows viewing (not editing) dataonly if the stored procedure has a CURSOR out parameter.
3) Field is filled only in case if TOraStoredProc returns CURSOR
4), 5) To use TOraStoredProc, you need a correctly configured TOraSession component. TOraStoredProc component cannot connect to the server by itself. You need to specify an existing TOraSession in the TOraStoredProc.Session property. You can choose the connections, configured in OraDeveloper Tools, in the Existing list of the TOraSession component.