Connecting to Oracle Database Instance

Welcome Forums General PowerShell Q&A Connecting to Oracle Database Instance

This topic contains 2 replies, has 3 voices, and was last updated by

 
Participant
3 years, 4 months ago.

  • Author
    Posts
  • #27788

    Participant
    Points: 0
    Rank: Member

    Hi, does anyone here use Powershell to connect to a database?
    I normally do this on command line, but anyone doing this on Powershell?

  • #27795

    Keymaster
    Points: 1,704
    Helping HandTeam Member
    Rank: Community Hero

    Lots of people do. If you look on our Resources menu, under ebooks, the Trend Reports book has some concise sample code that shows how. It's meant for SQL Server, but connecting to another brand is almost identical.

  • #27805

    Participant
    Points: 311
    Helping Hand
    Rank: Contributor

    For Oracle, keep in mind you will probably need to install the Oracle client to have the correct ODBC drivers installed. If it's a 64-bit system, keep in mind you will need the appropriate drivers installed. ODBC drivers are separated as 32 and 64 bit, so if you use 64 bit Powershell, you will need 64-bit ODBC drivers installed. I typically install the drivers first and then look at how to build the connection string for the installed ODBC driver.

The topic ‘Connecting to Oracle Database Instance’ is closed to new replies.