Recent content by Hans Erik Busk

I would be very interested, as I am using spatial for an epidemiological purpose, and an easy way to visualize ad hoc queries would be very valuable.

You can do that in configure/preferences/user interface/options/autosave desktop Hans Erik Busk

Thank you for the suggestions, but TNS_ADMIN points to the new home's directory, and the active home is ORANT whith forms6i files. Both places contains valid tnsnames.ora files. Strange thing is that PL/SQLdeveloper connects fine, given the rigth database name.

After upgrading from 9.2 to vers. 10G and dropping the Ora92 directory, the dropdown box for database in the logon dialog is empty. I hove no problem logging on though. The same goes for my Direct Oracle Acces. I have of course double checked the tnsnames.ora file in all Oracle homes (including...

The ROWID is a special case as it is necessary for updating a row. Yes, I know that you can select "edit table" in the object browser, but sometimes I want to update a table after having written a query,with a couple of lookup-tables. It would be convenient just type "a." and let the code...

It would be nice if ROWID would show in code assistant together with the regular column names.

I am making som housekeeping for a standby database. For that purpose I would like to be able to connect to a running instance with the database shutdown, like I can do in SQLPLUS with "connect / as sysdba" However trying to connect with an OracleSession (ConnectAs=caSYSDBA LogonDatabase...

Is there a way to let DOA inherit the DB-connection from an Oracle Forms 6i application, running Net8 ? I guess DOA can recieve the necessary information through TOracleSession.ExternalSVC, but how to get that information from Forms?

It would be nice to have a component/function to make a printout of all the SQL-strings end possibly parameters associated with the DOA-components in a datamodule. Sometimes it is better to view a program listing on old-fashioned paper.

Yes, sure helped. The strange thing is that when the Delphi program is running it finds the right TNSNAMES file. According to Oracle docs the correct registry value should be in TNS_ADMIN, where the path for configuration files should override NET80 values. But not even Oracle developer 6.0...

Just a small problem. (Version 3.3 Delphi5) When using the property editor for OracleSession.LogonDataBase the names shown are taken from D:\ORANT\NET80\ADMIN\TnsNames.Ora instead of D:\oracle\ora81\network\TnsNames.Ora In the registry I have defined the NET80 parameter to the latter location...

Yes, but the problem is: where to get that parameter from the Oracle form?

I have a delphi vith DOA application that I call from a developer 2000 ver. 6 form. Is there a method for "handing over" the session information to DOA in order to avoid a new logon process to be initiated from the Delphi program? ------------------ busk