when I try connecting from pb 10 or 11 using the native
> driver to an oracle 11g 64 bit database i get this error:
> oracle library oci.dll could not be loaded.when i use an
> oracle odbc driver i get this message: data source name
> not found and no default driver specified. when i trying
> connecting from visual studio 2008 i get this message:
> attempt to load oracle client libraries threw
> badimageformatexception. this problem will occur when
> running in 64 bit mode with the 32 bit oracle client
> components installed.
1. Download the Oracle 11g 32 bit odac.
2. Unzip it into a temporary folder.
3. Run the setup. Install the insta-client without mdac.
The client will install in a subfolder called client_1 under
the
<drive>:jagonzo\product\11.1.0\ folder. For me this is fine.
4. Copy the tnsnames.ora file from the
<drive>:\app\jagonzo\product\11.1.0\db_1\NETWORK\ADMIN to
the clients
D:\app\jagonzo\product\11.1.0\client_1\Network\Admin folder.
I also copied the listener and sqlnet files to this folder.
5. That's it.
============================================================