Is your Clientready for SQLPSX with Oracle?

For those, who do not know, SQLPSX is a Codeplex project using PowerShell to access SQL-Server Databases using SMO and ADO.NET to acces SQL-Servers for adminstrative tasks and to execute querys on them. 

The newest release brought some integration into ISE the grafical Interactive Scripting Environment. You may look at http://www.youtube.com/watch?v=1KcNSHn7oTA to get an impression.

The modules OracleClient and OracleISE are new too and aim at establishing connections to and executing simple queries on Oracle servers. (Stored procedures returning refcursors and parameters are not yet supported).

Today I'm not describing how to use these modules, but I provide a test for you, to check if the needed components are installed.

The needed components are called Oracle Data Access Components
You need a computer with a orcale client including these components, you need PowerShell V2 running on it and you need how to connect to an Oracle Server using TNS names. 

Now lets execute a litte PowerShell, to see if the Oracle.DataAccess is found on your system

$a = [System.Reflection.Assembly]::LoadWithPartialName("Oracle.DataAccess")             
$a | fl            

If you get something like

CodeBase               : file:///C:/Windows/assembly/GAC_32/Oracle.DataAccess/2
                         .111.6.0__89b483f429c47342/Oracle.DataAccess.dll
EntryPoint             :
EscapedCodeBase        : file:///C:/Windows/assembly/GAC_32/Oracle.DataAccess/2
                         .111.6.0__89b483f429c47342/Oracle.DataAccess.dll
FullName               : Oracle.DataAccess, Version=2.111.6.0, Culture=neutral,
                          PublicKeyToken=89b483f429c47342
GlobalAssemblyCache    : True
HostContext            : 0
ImageFileMachine       :
ImageRuntimeVersion    : v2.0.50727
Location               : C:\Windows\assembly\GAC_32\Oracle.DataAccess\2.111.6.0
                         __89b483f429c47342\Oracle.DataAccess.dll
ManifestModule         : Oracle.DataAccess.dll
MetadataToken          :
PortableExecutableKind :
ReflectionOnly         : False

the needed assembly is present and you can start to wait for me telling you how to use the modules.

Bernd