Recent content by Shahine

Hi, I hope you can help me? When conneting to Oracle-10 using DOA 4.0.3.0 I get the error: "SQL *Net not properly installed" "OracleHomeKey: SOFTWARE\ORACLE" "OracleHomeDir:" I believe this has been fixed in DOA 4.0.5.0 ? When connecting using Oracle-9i Client then if I query a table with a...

Any more news on DOA components for Delphi8 for .net? Will it use the Oracle ODP interface for example? Any kind of time-scale as when more information will be available?

Hi. Is there a way of creating an Oracle-9i database so that all Varchar2 type fields can be "case insensitive" for searches? Instead of using Upper(fieldname) Like ... Many Thanks Shahine.

Hi.. I have a table with Long Row field. Querying this table over a 576kbps link is quite slow, is there anything I can do to speed up the query? This table does not contain many records (100 Max). The Long Row field is used to store a Report-Builder report template, and they are typically...

Thanks I'll give this a go.. Shahine..

Hi.. One of our customers is reporting slow connection to Oracle (some times)? We are using Delphi-6 Ent with DOA 3.4.6.1 to connect to Oracle-9i using TNS. The clients have the variable TNS_ADMIN and are pointing to a central network for the TNSNAMES.ORA Most of the time the connection (Time...

Hi... Is there a way of globally limiting the number of rows that are returned by all queries? Something similar to MAX ROWS in BDE? I have used "QueryAllRecords=False" and "ReadBuffer=25" and it works fine on individual queries but when I use Report Builder (with DOA) I get multiples of 25...

Thanks...

Hi.. What is the minimum requirement for a client pc (windows 2000) to be able to connect to an Oracle-9i Server? Do we have to install Oracle-9 Client on every machine? The tnsnames.ora files on all the client machines are nearly identical, can we not use a central location for them rather...