Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Installing an ODBC for 11g on Win 7 64 Bit Nearly Impossible

user9334236Nov 17 2015 — edited Nov 19 2015

Does anyone know how to do this in less than 30 steps, after uninstalling and reinstalling all the software and DB several times?

It basically just cost me a job, because lacking an ODBC, working from home, I can't run ADO, OLEDB, even link tables in Access so I can run ADO or DAO into THAT.

Seriously, I've pulled data from a mainframe OS2 into Excel with less trouble. If Oracle can't handle a simple ODBC like IBM, something is very wrong.

They are the most common, universal connection objects in the world. Why does this have to be like pulling teeth?

Comments

Billy Verreynne

You created an ACL. You get an ACL error. You do not detail/show the ACL created.
But you expect us to comment on what is wrong with your ACL?

ravindra Thapliyal

Hy Billy, please can you let me know what ACL really works for because I'm new to the apex and facing the same problem, do you have any docx regarding how we can use ACL in FTP

Billy Verreynne

12c:
DBMS_NETWORK_ACL_ADMIN (0 Bytes)19c:
PL/SQL Packages and Types Reference (0 Bytes)

User_IKHJ2

I have used these code for creating ACL and Add privilege.
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
ACL => 'ftp.xml',
DESCRIPTION => 'Network Access Control for HRDEPT',
PRINCIPAL => 'HRDEPT',--Schema name in which app is installed
IS_GRANT => TRUE,
PRIVILEGE => 'connect');
END;

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE (
ACL => 'ftp.xml',
PRINCIPAL => 'HRDEPT',
IS_GRANT => TRUE,
PRIVILEGE => 'connect',
POSITION => NULL);

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
ACL => 'ftp.xml',
HOST => '192.168.2.150',--FTP Host Name
LOWER_PORT => NULL,
UPPER_PORT => NULL);

Billy Verreynne

Your posted SQL code uses a hostname. The ACL uses an IP. The schema does not have resolve privs.
Grant the resolve privilege in addition to the connect privilege.

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 17 2015
Added on Nov 17 2015
#odbc, #windows-and-net
12 comments
4,098 views