This function will let you create a database connection object for connecting to an Oracle database. It supports the usual parameters; DatabaseServer, DatabaseName, Port and Credential and will return a MySqlConnection object.

If you have read my other functions for database connections (New-SqlConnection and New-MsSqlConnection), this one is a little bit different. It consists of two functions; one for creating a data source, and the function creating the database connection itself. This means you can use it both with tnsnames.ora or without (by creating you own data source string, and passing this to the New-OracleConnection function).

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s