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!

Windows 7 - ODBC for Office 2010 64 bit - MS ODBC Driver for Oracle

jefferamJan 8 2010 — edited Jul 13 2011
I am trying to link a table from an oracle rac 10.2.0.4 64 bit install.
I have windows 7 with the oracle 64 bit client.
in odbc i can create a datasource using the oracle driver
and when i try to link a table i get an error :
Reserved error (-7732); there is no message for this error.

I would like to use the Microsoft ODBC for Oracle Driver but it doesnt exist on my computer.
the old one on windows xp used file MSORCL32.DLL is there a MSORCL64.DLL now?
Anyone have any help?
Jeff

Comments

843834
Your idea is interesting. But then, XML is an SGML derivative that follows standards laid down by its parent. I guess what you are suggesting is another standard.

I do not completely agree with ur point that XML start & end tags duplicate information. Rather it improves readability of the document.

Its always better to say bValidationRequired than bValReq, the intrepretations could vary on the latter.


Just my thoughts.
843834
Hi Sanjaya,
in ur case there are only 2 elements. when there are lot of elements in ur xml file, not ending with the closed tag with the element name will lead to a confusion & especially when u start writing transformations it would be more tedious.
cheers
anand
843834
Hi All:

I think you missed a point!! Why do I want readability. I think I am not going to write Email in XML:-):-). It is data exchange mode between programs. I think in that case I will have to say: TCP/IP is not readable :-).

AT least for those cases, where programs talk to each other, you DO NOT need human readability.

Nice to hear all your ideas. So nice....

-Sanjay
843834
Hey Sanjay,

Well you mentioned that readability in XML scores low when it is used for exchanging data. I am pretty sure that XML is NOT only intended for data exchange. It is useful in other situations too. Think of XML Content Mgmt (just to say). You definitely need readability here, thou the actual content may be published in a totally diff way.

XML's main purpose is to have custom document structure. It is data/Content driven. Anything that is data centric, MUST be readable too. Why do you have custom document structure is another question and ur point (data exchange) comes into picture as well :-).

Do you agree now?

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

Post Details

Locked on Aug 10 2011
Added on Jan 8 2010
#11g, #client, #connection, #excel, #odbc, #oracle, #query, #windows, #windows-and-net, #xe
39 comments
112,340 views