$connectstring = "DRIVER={MySQL ODBC 5.1 Driver};Data Source=MySQLLinux;Server=Linux.lan;database=tom;Uid=tom;Pwd=bunvegni;OPTION=3;" $sql= "select * from tom.tom3" $OLEDBConn = New-Object System.Data.ODBC.ODBCConnection($connectstring) $OLEDBConn.open() $readcmd = New-Object system.Data.ODBC.ODBCCommand($sql,$OLEDBConn) $da = New-Object system.Data.ODBC.ODBCDataAdapter($readcmd) $dt = New-Object system.Data.datatable [void]$da.fill($dt) $OLEDBConn.close() return $dt