I am trying to connect to a Oracle 12c database from Excel 2016 using 64-bit ODAC 12,2c Release 1 for windows x64. I go to get data and choose Oracle Provider for OLE DB, in Data Link Properties page I fill in details, with the user database specified, and test the connection, which is a success. Instead of showing the user database the system database is shown (Schema tables like OPS$Username, SYS…). Any idea why I cannot see the user database using OLE DB but I can using ODBC with MS Query?
Cannot see Oracle database using OLE DB
337 Views Asked by Danny At
1
There are 1 best solutions below
Related Questions in EXCEL
- Power Query / M Code, extract a list of tables into one main table, some column headers same but some different and in different order (and in row 2)
- Is there a way to validate the cell format (from excel) to fetch the symbol from it (in Java)?
- Excel - Visual Basic, macro with autofill "1"
- Getting Run-time error '13': Type Mismatch using .Find
- Getting website metadata (Excel VBA/Python)
- Excel Code Editor doesn't work (blank window)
- How to find out how many of each 2, 3 and 4 required to fit in 100 using excel?
- How would I apply a rather complex summation formula like this in Excel?
- Removing a Button from Customized Excel Ribbon
- Excel - Update Item Description Based on Accessories Ordered with It
- select duplicates from data based on another column
- How to use VBA to bold just some text
- VBA Code to filter and get values from csv to excel worksheet
- Look up max alpha numeric value
- Azure Batch for Excel VBA
Related Questions in DATABASE
- How to add the dynamic new rows from my registration form in my database?
- How to store a date/time in sqlite (or something similar to a date)
- Problem with add new attribute in table with BOTO3 on python
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- SQLAlchemy: efficient relationship loading in 3-way many-to-many relationship
- Cannot connect to Postgres Database when running Quarkus Tests with Gitlab ci
- Local or remote database with react-native?
- I want to edit a specific row in database
- How to enter data in mongodb array at specific position such that if there is only 2 data in array and I want to insert at 5, then rest data is null
- Open Web Library
- database login.py and register.py error showing 404 file not found and doesn't work
- SQL71561: SqlComputedColumn: When column selected
- Liquibase as SaaS To Configure Multiple Database as Dynamic
- Updated max input vars but table still shows error
- Spring does not map set of roles
Related Questions in ORACLE
- sqlplus myusername/mypassword@ORCL not working with Oracle on Docker
- Oracle setting up on k8s cluster using helm charts enterprise edition
- Oracle Managed Data Access Client can't work from IIS but work for local debug environment
- If composite indexing created - indexing is called?
- Oracle Http server ISNT-07551
- why here not creating table?
- Data migration from Oracle Database Clob to GCP Bucket
- SQL Alchemy custom type, forcing blob bind parameter
- How to send message to syslog agent in plsql
- Whatever the data available in previous record it should add to the new record
- I have an Oracle SQL query that is giving me a "ORA-00918: column ambiguously defined" error on a line that is a comment line
- 'ORA-12170: TNS:Connect timeout occurredORA-12170: TNS:Connect timeout occurred' ERROR while working on oracle with laravel
- Is their any way i can open parallel query tabs
- VSCode Libraries not showing for New Java Project
- I can't ssh to my instance, Connection refused
Related Questions in OLEDB
- Published MAUI app doesn't work with access database
- "Microsoft Access database engine cannot open or write to the file" when trying to open connection with ADODB to query .csv files
- DB2 SQL0104N An unexpected token "?" was found following ""
- OLE DB Origin connection dynamically changes and retrieves settings from a table
- Code working to input data into access database but when retrieving the data "Column "XYZ" does not belong to table ."
- C# & OleDB error with SQL parameterized query
- VS2022: ODBC Driver Manager Error: Data source name not found and no default driver specified
- Download File Missing Inserted Data
- How to Capture OLDBC Warning/Error message Captured from LinkedServer
- no read permission on 'table' - OleDb & Microsoft Access Database
- Cannot apply indexing with [] to an expression of type 'DataColumn' C#
- Search per ID on access using Visual Studio 2022 VB.NET
- Image from MS Access in WPF
- Trouble with displaying Excel data in a C# program using the oledb library
- (Excel Source) File Processing SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005
Related Questions in ODAC
- Reconnect Oracle Database if disconnected
- How to connect to Oracle DB using ODAC and Oracle data access library in .net 7
- I get the following error on Report Builder and Visual Studio after sucessful installation of ODTwithODAC183
- Delphi access bind variable through TOraDataSet of ODAC
- Oracle tools not available on Visual Studio 2019 Community edition
- Weird behavior: ASP.NET application still run even if I input the wrong version of ODAC into Web.config. What happen?
- Entityframework core 7 with Oracle database in .Net 6 application
- C# oracle execute non query with array bind count error with OracleDbType
- How to resolve Oracle error-"User Id' is an invalid connection string attribute"-using PowerShell?
- Cannot see Oracle database using OLE DB
- Powershell 5.1 using Oracle Data Provider for .NET, query result not in table
- Invalid casting error when recurring division result is read using OracleDataReader
- Entity Framework runtime error when parsing edm mappings in web.config
- error executing exe file built using dotnet
- Oracle.ManagedDataAccess.Client with Proxy User has error ORA-01017: invalid username/password; logon denied
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
I created a system ODBC to Oracle through control panel as admin. In Power Query, go to new data source, other sources, odbc. The new system ODBC will be there