Per instructions, I downloaded the instantclient-basic-nt-11.2.0.3.0.zip and instantclient-odbc-nt-11.2.0.3.0.zip files, unzip them and then modified the Path system Variable value for the folder that contains the instantclient and odbc information. Once all done, for some reason, the Oracle 32-bit driver cannot be verified in the ODBC Data Sources. My question is:
Download Oracle 32 Bit Odbc Drivers
Use the following procedure to download the Amazon Redshift ODBC drivers for Windows operating systems. Only use a driver other than these if you're running a third-party application that is certified for use with Amazon Redshift and that requires a specific driver.
Use the steps in this section to download and install the Amazon Redshift ODBC drivers on a supported Linux distribution. The installation process installs the driver files in the following directories:
Viewed 1000+ timesYou Asked I need to install Oracle database software client 18c on win 7 32 bitI visit Oracle website. They only offer instant client without setup file.i don't know configure on win 7.especially about odbc technology. I want to open odbc windows 32 bit and see the driver Oracle and Connor said...I assume you're starting here -085727.html If you download the ODBC package, the installation instructions are right there in the zip fileInstalling Instant Client ODBC------------------------------1. Install the Instant Client Basic or Basic Light. Download Instant Client Basic or Basic Light package from OTN and unzip it into the designated directory (e.g. C:\oracle\product). Once the package is unzipped, a new directory with name instantclient_XX_Y (where XX refers the major version and Y refers the minor version of Instant Client) is created under the designated directory (e.g C:\oracle\product\instantclient_XX_Y). Under this new directory, all the libraries and files related to Instant Client are stored. Note: The Instant Client Basic Light doesn't support non-ASCII characterset. So the Japanese version of Oracle ODBC driver can be installed only with Instant Client Basic package. 2. Now unzip the downloaded Instant Client ODBC from the same designated directory where the basic or basic light was unzipped. Instant Client ODBC package has the following files/shared libraries under the Instant Client directory (instantclient_XX_Y): ---------------------------------------------------------------------------- File name Description -------------------------------------------------------------------------- sqora32.dll Oracle ODBC driver DLL sqoras32.dll Oracle ODBC driver setup DLL sqresus.dll Oracle ODBC driver resource DLL ODBC_README (this file) odbc_install.exe Oracle Instant Client ODBC driver installer odbc_uninstall.exe Oracle Instant Client ODBC driver uninstaller ----------------------------------------------------------------------------3. Execute odbc_install.exe to install the Oracle ODBC driver from the Instant Client directory. Usage: odbc_install.exe [JA] - The odbc_install.exe installs the English version of Oracle ODBC driver by default. When it is started with optional argument JA, then it will install the Japanese version of Oracle ODBC driver. For e.g.: C:\oracle\product\instantclient_XX_Y> odbc_install.exe - installs the English version of Oracle ODBC driver. C:\oracle\product\instantclient_XX_Y> odbc_install.exe JA - will install the Japanese version of Oracle ODBC driver. - It should be started with Administrator privilege in order to install the Oracle ODBC driver successfully. - The installer will include the Instant Client directory name as part of the driver name while registering the Oracle ODBC driver in ODBC Driver Manager on Windows. For e.g.: Driver name will be "Oracle in instantclient_XX_Y" if it is installed from C:\oracle\product\instantclient_XX_Y. - It is mandatory to have the Instant Client Basic or Basic Light binaries in the current (Instant Client) directory, to install the Oracle ODBC driver successfully. Rating (4 ratings)Is this answer out of date? If it is, please let us know via a Comment Comments Comment successfullNam, June 11, 2019 - 3:42 pm UTC
Note: Tableau connectors using JDBC drivers require Java to run. If Java is not already installed on your computer, download and install the latest Java 8 version. There are many options available. We recommend downloading from
Pivotal Greenplum Database uses PostgreSQL drivers. If you don't have PostgreSQL drivers installed, follow these instructions to download and install the Linux 64-bit PostgreSQL driver for Tableau Server.
Note: The Zendesk driver is a JDBC driver so it doesn't require a odbc.ini file. 1. Click Download. The JDBC driver for Zendesk will download onto your computer.2. Unzip the file, and then copy it to the following directory.
The installation process is fairly easy. First, you need to extract the files from the binary tarball. Then, you need to install the driver's shared library to the appropriate place in your system. The driver's shared library is called libmaodbc.so and it is located in either the lib directory or the lib64 directory, depending on whether you downloaded a 32-bit or 64-bit package. The driver's shared library can be installed anywhere, but for simplicity, the instructions below will assume that you are installing it to /usr/lib64, which is a common directory for 64-bit shared libraries on many Linux distributions.
Hi all, I got the same problem. i tried to install different version of oracle client and finally I only find the Oracle Client 10g1 and install the ODBC and OLEDB drivers. I could sucessfully testing the connection to an Oracle 9i database in another Unix machine throught Net Manager. However, when I setup the ODBC or OLE DB connection in SQL Server 2005. I always got the following error:
Note: Iguana may not always support the very latest version of Oracle drivers, so you can simply download an earlier version if necessary. This is particularly true if you are not able to use the the latest version of Iguana.
Downloads are available in source and binary formats at the PostgreSQL downloads sitepsqlODBC DocumentationThe following documents contain various bits of useful information. Please send any additional documentation, or report errors/omissions to pgsql-odbc@postgresql.org
From this link, the Microsoft ODBC drivers for SQL Server can be downloaded and installed. Depending on which Windows operating system version (32-bit or 64-bit) is used, there are two versions of the Microsoft ODBC drivers for SQL Server that can be installed:
In case that the wrong version of the Microsoft ODBC drivers for SQL Server is trying to be installed (e.g. x86\msodbcsql.msi on the Windows 64-bit version), the following warning message will appear:
Verena,\\nThanks. That link got me one step closer. I was using the 64bit ODBC Admin tool. Using the 32bit tool worked. I now have an ODBC connection to Oracle. I'm having trouble now establishing a connection from Crystal Reports XI. See my reply to Abhilash. \",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"former.employee\",\"displayName\":\"Former Member\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":true,\"isCurrentUser\":false,\"id\":9849377,\"creationDate\":1361548991000,\"activeRevisionId\":10577432,\"lastActivity\":1361548991000,\"parentId\":9848034,\"originalParentId\":9847068,\"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}]},\"9848615\":\"rootParentId\":9848615,\"commentsCount\":5,\"comments\":[\"body\":\"1) Back to the same issue. I got a new pc and trying to setup CR XI R2 SP6. The software installed ok. I'm running on a Windows 7 64bit machine and trying to establish an ODBC connection to my Oracle database. I'm using the 32 bit ODBC Admin tool and I see the CR Oracle ODBC Driver 5.3 that I selected the last time. I chose that and proceeded to setup my connection. When I test the connection, I am getting this error. The CRor823.dll file is in that directory. What else can I check? \\n \\n \\n \\n2) I registered the software and never got a registration code. The software was purchased and licensed but because I don't have a code, it keeps reminding me that it is not registered. How do I get a code once I am already registered?\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"abhilash.kumar\",\"displayName\":\"Abhilash Kumar\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":10467505,\"creationDate\":1385411352000,\"activeRevisionId\":11090656,\"lastActivity\":1385411353000,\"parentId\":9850321,\"originalParentId\":9847068,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[\"id\":1013098,\"fileName\":\"SysWOW.JPG\",\"size\":\"21.1 kB\",\"url\":\"/storage/attachments/1013098-SysWOW.JPG\",\"isImage\":true],\"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: 9847068, plug: "odbc-drivers-for-crystal-reports-xi-on-windows-7-6", votes: 0, questionTitle: "ODBC Drivers for Crystal Reports XI on Windows 7 64bit", 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: true , childToViewInfo: id: "" , comments: JSON.parse("\"9848034\":\"rootParentId\":9848034,\"commentsCount\":1,\"comments\":[\"body\":\"Verena,\\nThanks. That link got me one step closer. I was using the 64bit ODBC Admin tool. Using the 32bit tool worked. I now have an ODBC connection to Oracle. I'm having trouble now establishing a connection from Crystal Reports XI. See my reply to Abhilash. \",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"former.employee\",\"displayName\":\"Former Member\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":true,\"isCurrentUser\":false,\"id\":9849377,\"creationDate\":1361548991000,\"activeRevisionId\":10577432,\"lastActivity\":1361548991000,\"parentId\":9848034,\"originalParentId\":9847068,\"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],\"9848615\":\"rootParentId\":9848615,\"commentsCount\":5,\"comments\":[\"body\":\"1) Back to the same issue. I got a new pc and trying to setup CR XI R2 SP6. The software installed ok. I'm running on a Windows 7 64bit machine and trying to establish an ODBC connection to my Oracle database. I'm using the 32 bit ODBC Admin tool and I see the CR Oracle ODBC Driver 5.3 that I selected the last time. I chose that and proceeded to setup my connection. When I test the connection, I am getting this error. The CRor823.dll file is in that directory. What else can I check? \\n \\n \\n \\n2) I registered the software and never got a registration code. The software was purchased and licensed but because I don't have a code, it keeps reminding me that it is not registered. How do I get a code once I am already registered?\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"abhilash.kumar\",\"displayName\":\"Abhilash Kumar\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":10467505,\"creationDate\":1385411352000,\"activeRevisionId\":11090656,\"lastActivity\":1385411353000,\"parentId\":9850321,\"originalParentId\":9847068,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[\"id\":1013098,\"fileName\":\"SysWOW.JPG\",\"size\":\"21.1 kB\",\"url\":\"/storage/attachments/1013098-SysWOW.JPG\",\"isImage\":true],\"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\":\"Hi Jack,You should consider upgrading CR XI to CR XI R2 SP6 for Windows 7 support as a first step.As far as the database drivers are concerned, I'm not too sure if you can find Oracle drivers here. Why don't you install Oracle Native client or perhaps DataDirect's drivers for Oracle?-Abhilash\",\"author\":\"username\":\"abhilash.kumar\",\"displayName\":\"Abhilash Kumar\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":9848615,\"posted\":1361530555000,\"votes\":2,\"isAccepted\":true,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"score\":2,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"accepted\":true,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Hi Jack,sorry, but the SAP Application Interface Framework is a tool for implementing and monitoring interfaces. It is not related to Crystal Reports.I moved your question to the SAP Crystal Reports - Data Connectivity space, I think there someone will be able to help you. In this space I also found this blog: , maybe it does help...Best regards,Verena\",\"author\":\"username\":\"former.employee\",\"displayName\":\"Former Member\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":true,\"isCurrentUser\":false,\"id\":9848034,\"posted\":1361520171000,\"votes\":1,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"score\":1,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Guys I Tried this:\\n\\nGo to system variables in your windows 7 environment and add a system variable:\\n1 Right click on computer--> left panel (advanced settings)\\n2. System Properties window-->select advanced\\n2.1 Click on Environment variables\\n2.2 Add variable --> TNS_ADMIN variable value-->PATH of YOUR ORACLE TNS file location\\nEG: C:\\\\app\\\\USERNAME\\\\product\\\\11.2.0\\\\client_2\\\\network\\\\admin\\napp is a default directory set by the oracle client.\\n\\nThis works on my pc like a charm. \",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":10432696,\"posted\":1384311728000,\"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/9847068/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/9847068/answers.rss', answersAndComments: '/feed/9847068/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 Feb 21, 2013 at 08:23 PM ODBC Drivers for Crystal Reports XI on Windows 7 64bit 635 Views Follow RSS Feed Finding things on this site is extremely difficult and when I called in to support, they weren't any help either. Does anyone know where I can find the ODBC Oracle drivers for Crystal Reports XI running on a Windows 7 64bit OS? I found this page but it send me to the downloads area and I can't find the drivers there. I'm really frustrated with this portal. 2ff7e9595c
Comments