Oracle 10g works fine with oracle 8i clients. SQL plus, toad, they connect fine using the oracle 8i client.
But there are some reasons why it’s a good idea to move to Oracle 10g client.
1) Oracle 10g has an instant client which is very light 254 KB compared to 259MB for the runtime client.
2) Oracle 8i is getting a bit old and won’t be supported anymore.
3) It’s good to have some homogeneity in the IT parc. (at least for Oracle,not for printers but that’s another history)
So, I’ve been testing the instant client a bit because I found it cool.
It install just the basic to connect using TNS or ODBC. It doesn’t install any tools of its own. It means that when you install that client you might have some tools or application of your own to work with.
Things to know when Installing 10g instant client
1) After installing the Oracle 10g instant client, a new environment variable must be created.
Go to control panel> system> advanced tab> Environment variable.
Create a new system variable called TNS_ADMIN.
In the Value field, put the path where your tnsnames.ora and sqlnet.ora will be located.
Note: If you already have a folder called like that from Oracle forms for example, just point to that folder. It makes less work for future maintenance.
2) Very often, if not all the time, after installing the client, I tried to create my first Oracle 10g ODBC.But I got the following error message:
“The setup routines for the Oracle in instantclient10_2 ODBC Driver could not be loaded due to system error code 126”
“Could not load the setup or translator library”
Well it’s an error, let’s check Metalink to see what they say about it.
Brilliant! They describe the error exactly as I have it.
Here is the article. You will need a metalink login to get it.
What Oracle say
This error may occur for the following two reasons.
1. There is not a mfc71.dll and msvcrt.dll located on the pc that the Instant Client is installed on.
2. The directory that mfc71.dll and msvcrt.dll is in is not included in the path environment variable.
To implement the solution, please execute the following steps:
1. Find the mfc71.dll and msvcrt.dll if it on your pc and include the directory in which it is in in the path variable. It is normally found in the C:\WINDOWS\system32 directory. Or copy mfc71.dll and msvcrt.dll to the directory where the instant client is installed.
2. If you have installed the full Oracle Client and ODBC Drivers for version 10.2.0.1 both mfc71.dll and msvcrt.dll are located in the ORACLE_HOME\bin directory
It couldn’t be that easy
Ok. First of all I check if the two dlls are on my test computer. I check ORACLE_HOME\bin
None of them are in it. So it seems the instant client doesn’t install a couple of required dlls. But apparently windows should have it.
If it is, there are 2 solutions:
a) Modify the “path” variable in Control Panel>System>advance tab> environment variable> system variable and add the path where the dll should be. Logically it’s C:\windows\system32.
b) Copy the dlls from C:\windows\system32 to the location specify in the “path” environment described at point a)
OK let’s copy them: I found msvcrt.dll but there was no mfc71.dll in system32. I’m using Windows XP. I’ve tried with Windows 2000 too.
I had a runtime client installed on my computer to manage oracle. I decide to copy them from the bin folder on my computer and into the location specified in “path” on the test computer.
I have to admit at that point that I thought it would work. Well it didn’t.
I finally cleaned up the instant client installation 254KB and installed the runtime client 259MB.
Then I wanted to create my finally working ODBC connection.
Oupsy: There’s no ODBC driver installed with the runtime client.
But this time it’s easy.
On top of that runtime client, make a new installation but this time customized, make sure to use the same home. Locate Oracle 10g ODBC and install it.
Finally, it’s possible to enjoy the new ODBC driver.
To get Oracle 10g ODBC driver installed and working on your computer:
1) Install Oracle runtime client
2) Install Oracle 10g ODBC driver on top of that using a customized installation.