NiceMan331
asked on
Connect To ODBC
Hi
i have new Desktop , windows 10 - 64 bit
dint have any oracle product installed
only i have connection path to the oracle server of the company
the question is :
what is the requirement to connect MS Access to Oracle Database Via ODBC
IS IT REQUIRED TO INSTALL local Oracle database on my desktop
i have new Desktop , windows 10 - 64 bit
dint have any oracle product installed
only i have connection path to the oracle server of the company
the question is :
what is the requirement to connect MS Access to Oracle Database Via ODBC
IS IT REQUIRED TO INSTALL local Oracle database on my desktop
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I prefer the minimalist method: Only install what you need.
I would go with the Instant Client.
You will need two downloads:
Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
Instant Client Package - ODBC: Additional libraries for enabling ODBC applications
All you need to decide is if you need the 32Bit or 64Bit. That is specific to the apps that use them not the OS it installed in.
32Bit Acess will need 32Bit drivers and as mentioned above, the 32Bit ODBC Manager:
http://www.oracle.com/technetwork/topics/winsoft-085727.html
I would go with the Instant Client.
You will need two downloads:
Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
Instant Client Package - ODBC: Additional libraries for enabling ODBC applications
All you need to decide is if you need the 32Bit or 64Bit. That is specific to the apps that use them not the OS it installed in.
32Bit Acess will need 32Bit drivers and as mentioned above, the 32Bit ODBC Manager:
http://www.oracle.com/technetwork/topics/winsoft-085727.html
ASKER
You will need two downloads:
Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
Instant Client Package - ODBC: Additional libraries for enabling ODBC applications
can you plz help me on where i can find them ?
Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
Instant Client Package - ODBC: Additional libraries for enabling ODBC applications
can you plz help me on where i can find them ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
no , i have 64 bit , not 32
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
there are something goes wrong with me
I downloaded both files ( basic_All_Drivers ) & the Odbc Drivers
but when I tried to run as administrator, nothing happened, no installation was done
I repeated many times for both files
I downloaded both files ( basic_All_Drivers ) & the Odbc Drivers
but when I tried to run as administrator, nothing happened, no installation was done
I repeated many times for both files
Do not just double click the install file. Open a CMD prompt and manually run it. There are command line parameters you must provide.
ASKER
can you give me an example on the line which i have to provide
No. The options you select would be up to you.
Going from memory, I believe it is a .BAT file. If you run it with no options from a CMD prompt, it should have the help message that gives you the available options.
Going from memory, I believe it is a .BAT file. If you run it with no options from a CMD prompt, it should have the help message that gives you the available options.
ASKER
i tried many times , even from cmd prompt
but there are no responde
is required java installation ?
but there are no responde
is required java installation ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I was unsure whether I should recommend for deletion as we didn't get a positive feedback from the Questioner.
However, the thread contains all necessary information how to install ODBC drivers and therefore it might have helped nevertheless or will help others in future.
Sara
However, the thread contains all necessary information how to install ODBC drivers and therefore it might have helped nevertheless or will help others in future.
Sara
32 bit + 64 bit...
they will add all required drivers & tools (ODP .Net ODBC OLE etc)...
you never know which one is needed and when :)