DOA on Oracle 6?

[gouldstone]

Hi

My client has just mentioned to me that they are running Oracle version 6 (after developmwent on 8i).

Should I expect my DOA application to run with no modifications? - I don't use any version 8 specific features as far as I know.

When they run the application, they are getting a DLL error.

Many thanks
Steve

 

[Marco Kalter]

Oracle 6? I had no idea people were still using that.

To be honest I have no idea if this should work. What exactly is the DLL error? Which SQL*Net version are you using? Why don't they upgrade like everybody else has done 10 years ago?

------------------
Marco Kalter
Allround Automations

 

[gouldstone]

Thanks Marco.

Yes I didn't think anyone would still use Ora 6 - they seem to be confused about what the DLL error is as I cannot speak to the person who reported it.

They cannot even tell me if the program starts or if the error is when it tries to login.

The relevant people have gone home for the weekend now - so I will have to wait until Monday for any more info.

Someone there mentioned they may be using Oracle 8 on the server and a client that was also version 8 but "commonly known as 6". Is this something you have heard of? Maybe they mean 8.1.*6* client????

So I'm confused as to what they mean now and will have to wait for more details.

Steve

 

[Marco Kalter]

Maybe they mean Oracle Designer 6 or Oracle Developer 6. Both include the Oracle8 Client.

------------------
Marco Kalter
Allround Automations

 

[gouldstone]

Thanks Mark

Ah that could be it. I still haven't been able to speak to anyone there today, as they are all "in a meeting".

It is most frustrating when someone else does the integration testing of your software but you cannot communicate with them.

Crazy.

I'll hopefully find out more tomorrow again.

Steve

 

[gouldstone]

Originally posted by gouldstone:
Thanks Mark

whoops! sorry about that.

 

[gouldstone]

Well the problem is at image activation, Windows doesn't let it run, complaining about missing ORA805.DLL, although that DLL is present according to the client.

Even more strange, is that another DOA app runs OK on the same machine. The only difference between the two, is that the app that works has all its Oracle access functions in a DLL. For the new app, I inlined all the functionality.

Even a simple app that just tries to initialise the OCI DLLs without any DOA components on it:

uses oracleci;
...
var n : integer;
...
n := DLLinit;

ie doesn't even try to logon to Oracle fails with the same DLL error.

Any ideas?

 

[gouldstone]

The client has just informed me that clicking "OK" when the error box is displayed allows the application to run.

So DOA obviuously finds the correct DLLs even though Windows doesn't think it's going to.

Now I just have to get rid of that error message at image startup!

 

[Marco Kalter]

It's most likely a PATH issue. If the BIN directory of the Oracle Home is not in the PATH, problems like this can happen.

Perhaps you can verify this?

------------------
Marco Kalter
Allround Automations

 

[gouldstone]

Yes that was it!

They had a directory on the poath that was not mapped to a correct drive.

Thanks very much Marco.

Always the simplest things that take the longest to fix!

Steve