Share via

odbcを利用してＶＢＡからOracle接続する際にエラーになる

nakagawa kenzo 5 Reputation points
2023-08-31T05:40:47.2366667+00:00

Excel365（64ビット）Windows１０（64ビット）　OraClient12ｇ（64ビット）　VBAからTNSサービス名で接続する時にOraOLEDBpus12.dll：指定されたモジュールが見つかりませんとエラーになります。1台目のパソコンにではエラーでなかったのですが2台目はエラーになりOracle接続が出来ません。2台ともｏｄｂｃデータソースアドミニストレーター（64ビット）で接続は正常でした。解決方法をお教え下さい。

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,452 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,840 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,705 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 24,441 Reputation points Microsoft Vendor
    2023-08-31T09:04:56+00:00

    Hi,

    This is an English language forum, I suggest you transform the language to English. The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.