Recent content by brettf

Thanks for the information. - Brett Fattori Online Technologies Corp.

I started having this problem and my solution was to captialize the TNS name. For instance, we used "bob.bizserve" for Oracle 7.3.4. When we updated to 8.1.6 this stopped working with TNS errors. Changing to "BOB.BIZSERVE" fixed it and all started working again. -- Brett Fattori Online...

Is it possible to use the EXEC command to execute a PL/SQL procedure, stored on the Oracle server, with a TOracleQuery component? My application seems to be hanging when I set the SQL to "EXEC Clear_Tracking" and call the Execute method. Is there a better way? -- Brett Fattori Online...

Then why does it hang up as soon as I connect the session? Nothing gets processed and I don't get anything from the service... I guess I could go to the next level and try to debug line by line... - Brett Fattori Online Technologies Corp.

Is it possible to use DOA in a TServiceApplication? I have a feeling the answer is going to be no, then I'll need some help as to how to go about using it in a service... Thanks! - Brett Fattori Online Technologies Corp.

Not during logon, but when I execute my first SQL statement. I seem to have been able to get around it, however. I needed to supply the service name as ALL CAPS. What I used to do, when I was using the older 8.1.x tools, was supply the service name in lowercase "bob.bizserve.com". I found...

When trying to connect to an Oracle 7.3.x database (after installing the 8.1.6 client tools) I am getting an ORA-00054 error. Assuming that my Oracle session object is named ORCL, I can call ORCL.Connected:=true; without any problems. As soon as I try to execute my first Oracle Query (named...