How to test an odbc connection with powershell ?

Asked By omarionalejandro 20 points N/A Posted on - 09/08/2012

Hi Experts,

I am having a odbc connection in my pc.I want to know how to test an odbc connection with powershell.I seek expert advice to get this done.I am having windows xp in my laptop.Thanks.

Regards,

Omarionalejandro

• Status: Open
• Question Views: 5339
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: DB2

Answered By Galaline Samuel 0 points N/A #131298

How to test an odbc connection with powershell ?

Hi,

Below are the two codes which can be used to test the ODBC connection in your system using powershell for that you need to write the powershell script which can be used for testing the database connection.

For SQL based systems below is the code.

 

function Invoke-Sqlcmd2

{

    param(

    [string]$ServerInstance,

    [string]$Database,

    [string]$Query,

    [Int32]$QueryTimeout=30

    )

 

    $conn=new-object System.Data.SqlClient.SQLConnection

    $conn.ConnectionString="Server={0};Database={1};Integrated Security=True" -f $ServerInstance,$Database

    $conn.Open()

    $cmd=new-object system.Data.SqlClient.SqlCommand($Query,$conn)

    $cmd.CommandTimeout=$QueryTimeout

    $ds=New-Object system.Data.DataSet

    $da=New-Object system.Data.SqlClient.SqlDataAdapter($cmd)

    [void]$da.fill($ds)

    $conn.Close()

    $ds.Tables[0]

 

}

 

 

For non sql based connections.

 

function Get-OLEDBData ($connectstring, $sql) {

   $OLEDBConn = New-Object System.Data.OleDb.OleDbConnection($connectstring)

   $OLEDBConn.open()

   $readcmd = New-Object system.Data.OleDb.OleDbCommand($sql,$OLEDBConn)

   $readcmd.CommandTimeout = '300'

   $da = New-Object system.Data.OleDb.OleDbDataAdapter($readcmd)

   $dt = New-Object system.Data.datatable

   [void]$da.fill($dt)

   $OLEDBConn.close()

   return $dt

}

 

About Galaline Samuel

Questions
1

Answers
201

Best Answers
54

• Vote Up 0 Vote Down

• Posted on - 09/08/2012
• Question Category: DB2