System.Data.OracleClient and powershell

-

i'm trying use powershell retrieve data local oracle server. when try use oracledataadaptor, fill data set, error need have oracle cliet software version 8.1.7. can fix installing odp.net, huge installation. need scrip portal. have looked using oracle instant client, c# tutorial found looks these need included in same directory executable. since powershell not operate same way, can give me advice how can deploy portable script can connect oracle 10g without type of software installation?

				[void][system.reflection.assembly]::loadwithpartialname("system.data.oracleclient")    				# connection information  				$connectionstring = "data source=serverip;user id=user_name;password=password"    				#standard sql query syntax  				$querystring = "select * table"    				$oracleconnection = new-object system.data.oracleclient.oracleconnection($connectionstring)  				$dtset = new-object system.data.dataset  				$oracleadapter = new-object system.data.oracleclient.oracledataadapter($querystring, $oracleconnection)    				[void]$oracleadapter.fill($dtset)  				  				  exception calling "fill" "1" argument(s): "system.data.oracleclient requires oracle client software version 8.1.7  or greater."  @ line:1 char:42  +                 [void]$oracleadapter.fill <<<< ($dtset)      + categoryinfo          : notspecified: (:) [], methodinvocationexception      + fullyqualifiederrorid : dotnetmethodexception

hello!
it better use oracle data provider .net (odp.net):

$assemblyfile = "c:\oracle\product\10.2.0\client_1\odp.net\bin\2.x\oracle.dataaccess.dll"  $connectionstring = "user id=username;password=password;data source=server;persist security info=true"  $commandtext = "select * table"  [reflection.assembly]::loadfile($assemblyfile) | out-null  $oracleconnection = new-object -typename oracle.dataaccess.client.oracleconnection  $oracleconnection.connectionstring = $connectionstring  $oracleconnection.open()  $oraclecommand = new-object -typename oracle.dataaccess.client.oraclecommand  $oraclecommand.commandtext = $commandtext  $oraclecommand.connection = $oracleconnection  $oracledataadapter = new-object -typename oracle.dataaccess.client.oracledataadapter  $oracledataadapter.selectcommand = $oraclecommand  $dataset = new-object -typename system.data.dataset  $oracledataadapter.fill($dataset) | out-null  $oracledataadapter.dispose()  $oraclecommand.dispose()  $oracleconnection.close()  $dataset.tables[0]




Windows Server  >  Windows PowerShell



Comments

Post a Comment

Popular posts from this blog

Azure MFA with Azure AD and RDS

-
i have setup following lab in azure , need help. a server (domain controller) , remote desktop services. and server multi factor authentication server. i have setup following one http://www.rdsgurus.com/uncategorized/step-by-step-using-windows-server-2012-r2-rd-gateway-with-azure-multifactor-authentication/ and when im connecting got following error. the user "domain\username", on client computer "xxx.xxx.xxx.xxx", did not meet connection authorization policy requirements , therefore not authorized access rd gateway server. authentication method used was: "ntlm" , connection protocol used: "rpc-http". following error occurred: "23003". also on security log i've got following authentication details: connection request policy name: ts gateway authorization policy network policy name: - authentication provider: radius proxy authentication server: test.test.local authenticati...
Read more

Failed to delete the test record dcdiag-test-record in zone test.com

-
ps c:\users\administrator.test> dcdiag /test:dns directory server diagnosis performing initial setup:    trying find home server...    home server = dc02    * identified ad forest.    done gathering initial info. doing initial required tests    testing server: default-first-site-name\dc02       starting test: connectivity          ......................... dc02 passed test connectivity doing primary tests    testing server: default-first-site-name\dc02       starting test: dns          dns tests running , not hung. please wait few minutes...          ......................... dc02 passed test dns    running partition tests on : forestdnszones    running partition tests on : domaindnszones    running partition tests on : schema ...
Read more

Failed to setup initiator portal. Error status is given in the dump data.

-
hi team, server configured boot san  after booting  facing issue windows server 2008 r2 system logs continuously generating iscsi port error event id 5 failed setup initiator portal. error status given in dump data. eventdata \device\raidport1 000004000100000000000000050000c0000000000000000000000000000000000000000000000000070200c0 binary data: in words 0000: 00040000 00000001 00000000 c0000005 0008: 00000000 00000000 00000000 00000000 0010: 00000000 00000000 c0000207 in bytes 0000: 00 00 04 00 01 00 00 00 ........ 0008: 00 00 00 00 05 00 00 c0 .......À 0010: 00 00 00 00 00 00 00 00 ........ 0018: 00 00 00 00 00 00 00 00 ........ 0020: 00 00 00 00 00 00 00 00 ........ 0028: 07 02 00 c0 ...À hi, please read through article below troubleshoot issue: error event id 5 logged in system log on computer uses iscsi software initiator connect iscsi target device http://suppo...
Read more