It would appear that the best I can acertain from this with working through as many combos as I can, that the Delphi 7 / Win 2K / Oracle XE combination does not work running everything on a dedicated machine.
Ok. I've now started a post mortem to find out why I've got Oracle XE 10.2.0 / DOA / Delphi 7 working fine on one machine, and has been fine for 6 months, and on the other hand current Oracle XE, DOA downloads not working on both Win2K and XP.
I shall look for the differences and see if I can...
No. I've been through the registry very carefully. There are no references to the old Oracle path or version. I've also used a registry cleaner that removes any references to folders and files that no longer exist.
The code to connect to the database has been the same code since we implemented...
Query Reporter also connects fine to the database. It's showing the tables, columns, allows me to pick the user name....
It's only my application which won't connect, and it has been rebuilt (cleared out all the DCUs) with the very latest Delphi 7 DOA...
As additional information the same application works ok with 10g XE on an XP machine, 8i on Win2000 machine.
The OracleAliasList has all the SIDs, the failure is at TOracleLogon.Execute.
Delphi7, Direct Oracle Access 4.0.7.1
I'm getting the same problem. I've succesfully managed to connect once before to 10g. The difference I've got this time is that (a) it's Windows 2000 and (b) it previously almost had Oracle 8i on, but the installation failed because the CPU was faster than it was expecting.
I've been through...
It would appear, that as postings about other versions of OracleLite that Oracle Client Adapter was dropped at 9i, and replaced by MSQL.
Are there any plans to make DOA work with OracleLite ?
From looking through past postings I see that DOA does not work with (except by force) OracleLite 9i - does it by any chance work with Oracle Lite 10g ??
Anyone tried and worked / failed ?
Yep - we can fix the open cursors (when we get access to a DBA who can and will change the value back : thank you corporate culture).
I was wondering if anyone had experiences the NT.DLL problem. Sounds to me like we might be getting the problem from something else.
If "open_cursors" fixes it...
We can't go to SP2 yet, because our customer has specified that SP1 is their current environment in which everything is tested (all was fine until SP1 came along, but in doing so they also changed the Oracle installation - apart from reducing number of cursors we're not sure what their...
We're suffering a problem when opening a database using Delphi 6 on Win 2000 (Sp1)
where we don't have enough "open_cursors".
This is only manifesting itself on the clients machine (and there DB people keep reseting our resources, so we keep getting the problem).
Anyone else had this and got a...