Reply To:

Hi,

If you want to connect an Oracle database to Database sidebar, you can do it this way:

  • Click on the second button Connect Database
  • Connection String dialog will open
  • Choose OLE DB as the data source
  • Click on the ellipsis button [...] for connection string
  • Database Selection dialog will show
  • Set Provider to OraOLEDB.Oracle
  • Set data source for your Oracle database server
  • Set your database name to initial catalog and specify the user and the password in the Authentication group

Similarly, you can use the database reverse engineering feature (Ribbon/Process/Reverse Engineering/Database)

Choose OLE DB as the data source and set the connection string in the same way as described above.

Dusan Rodina - softwareideas.net 11 April 2019 21:48:51

New Comment

Comment
You can use these formatting tags: [b]bold[/b] [i]italic[/i] [u]underline[/u] [url]www.example.com[/url] [code]some code[/code] [quote]quoted text[/quote] [list]one list item per line[/list]

Back to Oracle connection