Will an upgrade to 10G hurt my VB6 applications?

[abhijit]

We have several VB 6 applications. They use ADO and run against an Oracle 9i database, hosted on Unix.

Things that we typically do in VB6 code.

SELECT / INSERT / UPDATE / DELETE / CALL STORED PROCS


If we upgrade the database to 10G, are there any specific things that I need to watch out for?

What kind of testing do you recommend?

[Pino]

Chances are there will be no problems, most upgrades these days contain new features and better ways of doing things but still support the old features.

The best way to test this though is to simply set it up and run the app!

[Hack]

The best way to test this though is to simply set it up and run the app!

Preferably in a lab setting prior to rolling it out into production.

[Pino]

Preferably in a lab setting prior to rolling it out into production.

Of course!!

Let us know how it goes!

[JuggaloBrotha]

Just do the upgrade on the server and push the project straight to production then when it all fails tell your company to switch to sql server so future DB upgrades will be seemless

[abhijit]

Chances are there will be no problems, most upgrades these days contain new features and better ways of doing things but still support the old features.

The best way to test this though is to simply set it up and run the app!

I had an Oracle 10G Express Edition on windows setup on a test box. The ADO provider used by my application fails to retrieve data in long columns.

Preferably in a lab setting prior to rolling it out into production.

They plan to do this in the standard phased "dev / uat / production" routine.
There is only one developer for my applications. I wanted to have that pre-dev, so I am testing against a local windows box. My database, however is going to be on a 64 bit unix system. I am not sure if this is going to be an issue.

I shall keep everyone posted.

[RhinoBull]

We did the same conversion here to a brand new server.
We then ran various tests for each app that ever needed to connect to that db - once completed new server became new production.
Conversion as expected was practically troubles free.

[abhijit]

We got a test db in unix.

Me and my counterpart who handles the billing application are now tinkering with it.

All the Pro*C modules had to be recompiled.
My VB6 client is not calling any Pro*C modules, but the application that processes invoices is.

That's a batch process.