Using Oracle 10g with Oracle 8 drivers

[towsie]

Hi,

My work wish to move some of it's applications that conect to Oracle from 8 to 10g. I was wondering if someone could tell me if it is possible to use Orace 10g using Oracle 8 drivers?

Thanks

Towsie

[debasisdas]

Yes you can easily connect.

[towsie]

Hi,

I am able to connect ok. When using some of the functions that the application does it throws up errors. These do not appear when the application is connecting to Oracle 8. We are just trying to determine what is cauing the errors and we thought it would be a good idea to make sure that 10g will work correctly using oracle 8 drivers.

Thanks

Towsie

[debasisdas]

What exactly is the error ?

[towsie]

It always seems to fall over when trying to get data from a table. The front end is Access which isn't exactly the best and the errors don't seem to that helpful.

Most of the errors are,

"Object variable or With block variable not set"

[debasisdas]

"Object variable or With block variable not set"

That seems to be the problem with frontend code.

[towsie]

Yes, it does seem like that but it's strange that it has worked fine for years until we started testing with 10g.

[debasisdas]

Then its better to install 10g client.

[towsie]

Thats what we are going to do.

Thanks for help.

Towsie