We are planning to upgrade our database from Oracle 9i to Oracle 10.2.0.5. We currently have TeamDeveloper 2005 version application connecting from Windows server to Database on HP Unix via SQL client 9i version. Does TD 4.0 client with Oracle 9i works with 10g database? Not sure if we need upgrade the Oracle client version and TD to 5.1 also. We are trying to avoide application changes if possible.
http://www.guptatechnologies.com/Produc ... atrix.aspx
FYI, TD 2005 = TD v4.0. AS far as 'working,' it may or may not. We can only suggest you be sure to test to find out. I'd search this forum as well. Others have reported success stories with older TDs and newer DB client and server DBs.
I'd recomment to upgrade the Oracle client, because older client => newer database will probably not work 100%.
One hint for the upgrade:
When we did the first tests with 10g, we noticed that some selects returned NULL for expressions like "substr( varchar2_col, 1, 10 )" when the length of "varchar2_col" exceeded 254 characters.
We had to change the expression to "cast( substr( varchar2_col, 1, 10 ) as varchar2(10) )" to get it work again.
Who is online
Users browsing this forum: No registered users and 4 guests