Just the 32bit client (ODAC) - a 32bit client can connect to a 64bit database.
it is enought and
I think ODAC
it not for 32 bit or 64 bit - there are no instalation for 32 bit or 64bit there are only one and
which kind of instalion
Oracle Database Client Installation Types
You can choose one of the following installation types when installing Oracle Database Client:
- Instant Client: Installs only the shared libraries required by Oracle Call Interface applications that use the Instant Client feature. This installation type requires much less disk space than the other Oracle Database Client installation types.Included in the Instant Client installation is Instant Client Light. You may want to use this version of Instant Client if your applications generate error messages in American English only. The advantage of using Instant Client Light is that it has a much smaller footprint than regular Instant Client. Hence, your applications use less memory.
- Administrator: Enables applications to connect to an Oracle database on the local system or on a remote system. It provides tools that let you administer an Oracle database.
- Runtime: Enables applications to connect to an Oracle database on the local system or on a remote system.
- Custom: Enables you to select individual components from the list of Administrator and Runtime components.
Only Instant client ?
just the 32bit ODAC
32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio
Message was edited by: kgronau
1 person found this helpful
I have it install, but dont help me, if I want to create
there are only Microsoft ODBC for Oracle - no oracle drivers
and error message for Microsoft ODBC for Oracle - .. there are no components
1 person found this helpful
Check the registry key:
Do you see the Oracle ODBC driver there?
If not, something went wrong with your installation - make sure to execute the setup as Admin user.
I am deinstalled, I try to instal ones more, after the install I check for registry key, I am a Admin user I am sure
When I open ODBC drives there are default - not value, Oracle in instatclient_12_1 I instaled it when I want to connect to 12c database (I give up it ), Oracle in OraDB11g_home1 and SQL Server all is installed
I try it !
In ODAC I have to take the tnsname.ora or sqlnet.ora file from database 11g ? I mean C:\app\Administrator\product\11.2.0\client_1\Network\Admin
It is okey, but I dont try it in real, only tomorow
just gave it a try - downloaded the 32bit client using the link from above, applied it on a Win7 64bit OS as local admin. Right after executing the set up it asked me for the tns alias details, created the tnsnames.ora file and when I open the 32bit ODBC Admin the ODBC driver is installed. So created a 32bit SYSTEM DSN and tested the connection - works.
Thank you very much, you save my life
I made a connection between FT TM and Oracle, but the parameters, dont changes. Beacuse the automatic machine is not turn on, tomorrow I will go to Košice and try it, In table what I created and connect, may be will be datas from this machine. When everythink will going good.
Thank you very much, I am afriad what wil be tomorrow and nervous too
today, I cannot use database, tnsping is fail I kill myself, I dont understand, now I instaling database ... I dont know what to do, I think the ODAC has nothink with database, it is true ?
what's the error message you're getting using tnsping?
I check it, it was sqlnet.ora, i dont know why yesterday it was ok and today ... I instaled a new database and it is ok. Now I have new problem with FT transaction manager, my configuration is complet but I cannot start it (error message I have no privilies) I cannot understand it beacuse I am a only user of this aplication so I dont know what to do
Maybe Rockwell has also a Forum for FT transaction manager wher you can post your issue.