Oracle Odbc Driver System Error Code 193

The ODBC gateway requires a 32-bit ODBC connection. Use the 32-bit version of the Microsoft ODBC Administrator tool located in %systemdrive%\Windows\SysWoW64\odbcad32.exe to create the ODBC Data Source.

Creation of DSN fails with following error:The setup routines for the Oracle in instantclient_12_1 ODBC Driver could not be loaded due to system error code 126: The specified module could not be found. (C:\Oracle\instantclient_12_1\SQORAS32.DLL)

Oracle Odbc Driver System Error Code 193

Download

System Error 193 when configuring the 10.2A ODBC driver on Windows 64-bit. Creating a User or System DSN fails with system error 193. The 10.2A ODBC driver does not appear in the 32-bit version of the ODBC Administrator tool. The ODBC driver is listed in the 64-bit Data Source Administrator.

Error installing ODBC driver; PostgreSQL ANSI(x64) ODBC error 13: The setuproutines for the PostgreSQL ANSI(x64) ODBC driver could not be loaded dueto system error code 193: .. Verify that the file PostgreSQL ANSI(x64)exists and that you can access it.

MSI (s) (10:BC) [12:41:52:056]: LocalSQLInstallerError returned 0 in remote context.Error 1918. Error installing ODBC driver Oracle Instant Client Driver 21.3.0 x64, ODBC error 13: The setup routines for the Oracle Instant Client Driver 21.3.0 x64 ODBC driver could not be loaded due to system error code 193: .. Verify that the file Oracle Instant Client Driver 21.3.0 x64 exists and that you can access it.MSI (s) (10:BC) [13:04:58:907]: Product: Oracle Instant Client 21.0.3 x64 -- Error 1918. Error installing ODBC driver Oracle Instant Client Driver 21.3.0 x64, ODBC error 13: The setup routines for the Oracle Instant Client Driver 21.3.0 x64 ODBC driver could not be loaded due to system error code 193: .. Verify that the file Oracle Instant Client Driver 21.3.0 x64 exists and that you can access it.

Open Database Connectivity (ODBC) provides a standard interface that allows one application to access many different data sources. The application's source code does not have to be recompiled for each data source. A database driver links the application to a specific data source. A database driver is a dynamic-link library that an application can invoke on demand to gain access to a particular data source. Therefore, the application can access any data source for which a database driver exists.

Oracle ODBC driver is enhanced to prefetch LONG or LONG RAW data to improve performance of ODBC applications. To do this, the maximum size of LONG data (MaxLargeData) must be set in the registry on Windows (you also must add the registry key MaxLargeData in the data source name (DSN)), and set this manually in the odbc.ini file on UNIX platforms. This enhancement improves the performance of Oracle ODBC driver up to 10 times, depending on the MaxLargeData size set by the user. The default value of MaxLargeData is 0. The maximum value for MaxLargeData that you can set is 64 KB (65536 bytes).

When an application makes heavy calls to small packaged procedures that return REF CURSORS, a performance improvement can be made by forcing the driver to use OCIDescribeAny(). To enable this option, set the value of UseOCIDescribeAny in odbc.ini to T (True), default value is F (False), on UNIX platforms, and through the registry on Windows.

When an error occurs, the Oracle ODBC Driver returns the native error number, the SQLSTATE (an ODBC error code), and an error message. The driver derives this information both from errors detected by the driver and errors returned by the Oracle server.

Oracle Net Services errors and Trace logging are located under the ORACLE_HOME\NETWORK directory on Windows systems or the ORACLE_HOME/NETWORK directory on UNIX systems where the OCI software is installed and specifically in the log and trace directories respectively. Database logging is located under the ORACLE_HOME\RDBMS directory on Windows systems or the ORACLE_HOME/rdbms directory on UNIX systems where the Oracle server software is installed.

The Microsoft or unixODBC ODBC Driver Manager (Driver Manager) makes all ODBC drivers, regardless if they support Unicode, appear as if they are Unicode compliant. This allows ODBC applications to be written independent of the Unicode capabilities of underlying ODBC drivers.

The extent to which the Driver Manager can emulate Unicode support for ANSI ODBC drivers is limited by the conversions possible between the Unicode data and the local code page. Data loss is possible when the Driver Manager is converting from Unicode to the local code page. Full Unicode support is not possible unless the underlying ODBC driver supports Unicode. The Oracle ODBC Driver provides full Unicode support.

Convert Unicode function calls to ANSI function calls before calling the ANSI ODBC driver. String arguments are converted from Unicode to the local code page. For example, a call to SQLPrepareW is converted to call SQLPrepare. The text of the SQL statement parameter is converted from Unicode to the local code page.

If a column that contains character data is not bound by SQLBindCol, the Oracle ODBC Driver must determine if it must fetch the column as Unicode or as the local code page. The driver could default to receiving the column as Unicode, however, this may result in as many as two unnecessary conversions. For example, if the data were encoded in the database as ANSI, there would be an ANSI to Unicode conversion to fetch the data into the Oracle ODBC Driver. If the ODBC application then requested the data as SQL_C_CHAR, there would be an additional conversion to revert the data back to its original encoding.

• Hi Don,\\n\\nThanks for the quick help.\\n\\nThe oracle installed on our machine is of 64-bit. Will try installing CR on machine with 32-bit oracle and update yor accordingly.\\n\\nThe OS is windows server 2008 R2 SP1.\\n\\nShweta\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"don.williams\",\"displayName\":\"Don Williams\",\"groupIcons\":[\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":10790149,\"creationDate\":1395897509000,\"activeRevisionId\":11362157,\"lastActivity\":1395897510000,\"parentId\":10788856,\"originalParentId\":10787241,\"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: 10787241, plug: "odbc-connection-error-to-a-oracle-11g", votes: 0, questionTitle: "ODBC connection error to a Oracle 11g", 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("\"10788856\":\"rootParentId\":10788856,\"commentsCount\":1,\"comments\":[\"body\":\"Hi Don,\\n\\nThanks for the quick help.\\n\\nThe oracle installed on our machine is of 64-bit. Will try installing CR on machine with 32-bit oracle and update yor accordingly.\\n\\nThe OS is windows server 2008 R2 SP1.\\n\\nShweta\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"don.williams\",\"displayName\":\"Don Williams\",\"groupIcons\":[\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":10790149,\"creationDate\":1395897509000,\"activeRevisionId\":11362157,\"lastActivity\":1395897510000,\"parentId\":10788856,\"originalParentId\":10787241,\"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: 1, page: 1, pageSize: 10, pageCount: 1, sort: "votes" , answers: JSON.parse("[\"body\":\"Make sure the Oracle install path is in your PATH statement and only one Oracle client is installed.CR is a 32 bit app so your Oracle client must be 32 bit also.What OS are you testing this on?Don\",\"author\":\"username\":\"don.williams\",\"displayName\":\"Don Williams\",\"groupIcons\":[\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":10788856,\"posted\":1395847414000,\"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\":[]]"), answerForm: formAction: "/answers/10787241/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/10787241/answers.rss', answersAndComments: '/feed/10787241/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 Mar 26, 2014 at 09:34 AM ODBC connection error to a Oracle 11g 411 Views Follow RSS Feed I am having problem getting Crystal Reports 2011 to connect to an Oracle 11g R2 database via ODBC. I am able to configure the "Local Net Service Name" with out an issue. I can go into the ODBC connection and create a new connection for the database with no problem. Going into Crystal Reports 2011 I get the following error; 2ff7e9595c