Download Oracle 10g Client For Windows Xp 11 HOT!
Instant Client ODBC requires the Oracle Instant Client Basic or Basic Light package (depending on your locale requirements) also be installed. Download the desired package from OTN for your operating system and follow the installation instructions on the download page. For example, unzip the package to C:\instantclient_19_3 on Windows, unzip to /opt/oracle/instantclient_19_3 on Linux or other platforms, or use yum to install the RPM packages on Linux.
download oracle 10g client for windows xp 11
I tried heelclick as the service name first. Since it is such a popular database utility, I had to assume the obvious.\\n\\nSo now I've gone with your second suggestion and downloaded the Oracle ODBC driver. To keep things difficult, they didn't include an installation utility, and to make it more confusing, item 1 of part 4 of the installation instructions says it assumes Oracle Universal Installer has already been installed on my system. I don't know what that is, but I'm pretty sure it isn't already installed on my system. \\n\\nDo I need Oracle Database 10g Client Release 2 (10.2.0.1.0). I'm leaving work right now and I started the download (500 megs!). Tomorrow I'll give it a try, but if I'm heading in the wrong direction please let me know.\\n\\nThanks.\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"efstratios.karaivazoglou\",\"displayName\":\"Efstratios Karaivazoglou\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":7209763,\"creationDate\":1270769544000,\"activeRevisionId\":8463941,\"lastActivity\":1270771087000,\"parentId\":7189687,\"originalParentId\":7189703,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false}]}}"); const simplifiedQuestionView = JSON.parse("true"); (function() window.pageContext = mergeDeep(pageContext, question: id: 7189703, plug: "can't-connect-to-oracle-with-crystal-reports-xi", votes: 0, questionTitle: "Can\'t connect to Oracle with Crystal Reports XI", isClosed: false, isLocked: false, isRedirected: false, redirectedFromTitle: "", redirectedFromId: "", closedStatusData: JSON.parse(""), userVoted: false, relations: JSON.parse("\"canClose\":false,\"canUnredirect\":false,\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"canReopen\":false,\"type\":\"question\",\"canVoteUpOrCancel\":false,\"canViewRevisions\":true,\"canUnlock\":false,\"reported\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canCancelReport\":false,\"canComment\":true,\"isCurrentUserAuthor\":false,\"canViewReports\":false"), isQuestionAccepted: false , childToViewInfo: id: "" , comments: JSON.parse("\"7189687\":\"rootParentId\":7189687,\"commentsCount\":1,\"comments\":[\"body\":\"I tried heelclick as the service name first. Since it is such a popular database utility, I had to assume the obvious.\\n\\nSo now I've gone with your second suggestion and downloaded the Oracle ODBC driver. To keep things difficult, they didn't include an installation utility, and to make it more confusing, item 1 of part 4 of the installation instructions says it assumes Oracle Universal Installer has already been installed on my system. I don't know what that is, but I'm pretty sure it isn't already installed on my system. \\n\\nDo I need Oracle Database 10g Client Release 2 (10.2.0.1.0). I'm leaving work right now and I started the download (500 megs!). Tomorrow I'll give it a try, but if I'm heading in the wrong direction please let me know.\\n\\nThanks.\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"efstratios.karaivazoglou\",\"displayName\":\"Efstratios Karaivazoglou\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":7209763,\"creationDate\":1270769544000,\"activeRevisionId\":8463941,\"lastActivity\":1270771087000,\"parentId\":7189687,\"originalParentId\":7189703,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false]"), answerPager: answersCount: 3, page: 1, pageSize: 10, pageCount: 1, sort: "votes" , answers: JSON.parse("[\"body\":\"Try heelclick as service name. You may also want to try install, setup and use the Oracle ODBC driver instead. You can download this from oracle directly:\\n\\n \\n\\nRegards,\\n\\nStratos\",\"author\":\"username\":\"efstratios.karaivazoglou\",\"displayName\":\"Efstratios Karaivazoglou\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":7189687,\"posted\":1270154845000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"In order to setup connection with Oracle DB from CR try to do following: \\n \\n1) Find "tnsnames.ora" file on the machine where you run Crystal Reports (default location is: C:\\\\oracle\\\\network\\\\admin) \\n2) Add entry to the file in this way: \\n \\nheelclick =\\n (DESCRIPTION =\\n (ADDRESS_LIST =\\n (ADDRESS = (PROTOCOL = TCP)(HOST = hcoracle.heelclick.com)(PORT = 1521)\\n )\\n )\\n (CONNECT_DATA =\\n (SERVICE_NAME = heelclick.hcoracle.heelclick.com)\\n )\\n ) \\n3.) Save the file \\n4.) CR -> Create New Connection -> Oracle Server ("heelclick" as your Service Name) \\n \\nThis should make the trick.\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":7212399,\"posted\":1270816288000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"I figured it out. For anyone in the same boat, first download Oracle 10g Client. It's huge, but you only need to install the developer option with the basic client, which is half the size. Then open CR, use OleDB connection option with "Microsoft OLE DB Provider for Oracle", in the service name field put "//servername/servicename"... which in my case was "//hcoracle/heelclick".\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":7213301,\"posted\":1270834981000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[]]"), answerForm: formAction: "/answers/7189703/post.json", textareaName: "body", textareaErrors: "", isAttachmentsEnabled: true, answerEditorialGuideline: title: "Before answering", content: "You should only submit an answer when you are proposing a solution to the poster\'s problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.", links: [ title: "Rules of Engagement", href: " -of-engagement.html", ] , answerMinBodyLength: '10', answerMaxBodyLength: '20000' , currentUser: sapInternalId: '', permissions: canVoteUpOrCancel: false, canVoteDownOrCancel: false, canModerate: false, , isVotedUp: false, isVotedDown: false , alerts: alertModeratorMinLength : "It should be given a proper explanation about why the content is inappropriate.", alertModeratorMinLengthValue : "10", alreadyReportedMessage : "You already have an active moderator alert for this content." , url: profileApiBaseUrl: ' -api.services.sap.com', followUnfollowQuestion: '/sap/nodeSubscription.json', isFollowingQuestion: '/sap/isFollowingNode.json', vote: voteUp: '/commands/0/voteup.json', voteDown: '/commands/0/votedown.json', cancelVote: '/commands/0/cancelvote.json' , rss: answers: '/feed/7189703/answers.rss', answersAndComments: '/feed/7189703/comments-and-answers.rss' , authorizeUploadContext: type: 'answer' , atMention: userSearchServiceUrl: ' ', currentUserName: '', useNewUSSCORS: true, atMentionDelayMs: 100, showMentionInRedactor: true , attachmentSettings: commentMaxAttachments: '2', answerMaxAttachments: '10', commentMaxAttachmentSizeBytes: '1048576', answerMaxAttachmentSizeBytes: '1048576', commentAttachmentsSizeBytesTotal: '2097152', answerAttachmentsSizeBytesTotal: '10485760' , editor: editorClipboardUploadEnabled: true ) )(); Home
Community
Ask a Question
Write a Blog Post
Login / Sign-up Search Questions and Answers 0 Former Member Apr 01, 2010 at 08:42 PM Can't connect to Oracle with Crystal Reports XI 457 Views Follow RSS Feed Having many years of experience with SQL Server, I figured this was going to be easy... but it is not. I have Oracle (OraDB10g) running on a server and I've been asked to make some Crystal Reports based on it. So I tried creating a new connection. The Ole DB (ADO) option had a provider that looked like it would work called "Microsoft OLE DB Provider for Oracle". However, it prompts me for a Service Name in addition to user and password, and I have no idea what to give it for service name. I think I have all the info I need, I just don't know how to present it. The server that is running Oracle is HCORACLE, and using something called "Oracle Net Manager" on that server I can see the following: