golang通过odbc连接informix数据库
package main
import (
"database/sql"
"fmt"
_ "github.com/alexbrainman/odbc"
)
func main() {
var nombre string
//fmt.Println(" Conexion Go al Informix ")
dbRead, err := sql.Open("odbc", "DSN=gbase8s;")
if err != nil {
panic(err.Error())
}
err = dbRead.Ping()
if err != nil {
fmt.Println("error en el ping : ", err)
}
dbWrite, err := sql.Open("odbc","DSN=informix;")
if err != nil {
panic(err.Error())
}
err = dbWrite.Ping()
if err != nil {
fmt.Println("error en el ping : ", err)
}
//Query a ejecutar
rows, err := dbRead.Query("select name from t1;")
if err != nil {
fmt.Println("No va la Query :( ", err)
}
//Parse
defer rows.Close()
for rows.Next() {
err := rows.Scan(&nombre)
if err != nil {
fmt.Println("Error al parsear :( ", err)
}
fmt.Println(nombre)
_, err = dbWrite.Exec("insert into t1(name) values('" + nombre + "');")
if err != nil {
fmt.Println("dbWrit Error al parsear :( ", err)
}
}
err = rows.Err()
if err != nil {
fmt.Println(err)
}
//cerrar conexion
defer dbRead.Close()
defer dbWrite.Close()
}