I cannot get any rows, when I query a proc

[ymofen]

create proc xxx1
as
insert table_1 select 1
select * from table_1

golang

rows, err := db.query('exec xxx1');

rows.Columns();  // empty
rows.Next();    //  false

[mattn]

What is your:

• database
• connection string

[ymofen]

sql.open("adodb", "Provider=sqloledb;Data Source=127.0.0.1;Initial Catalog=dss_test;User ID=sa;Password=xxxx")

[mattn]

What server? sqlserver?

[ymofen]

sqlserver is mssql2014 or mssql2018 r2
/* sql proc /
ALTER procedure [dbo].[dss_list_proc]
@Instr varchar(64)='001',
@instr2 varchar(64)='002'
as
begin
/ unexception
if object_id('tempdb..#temp') is not null drop table #temp
select 1 as A into #temp
select * from #temp
*/

 /* will be ok */
 select 1 as A

end

golang code
func TestADODB(t *testing.T) {

str := "Provider=sqloledb;Data Source=127.0.0.1;Initial Catalog=dss_test;User ID=sa;Password=sa@2014"
db, err := sql.Open("adodb", str)
if err != nil{
	fmt.Println(err)
	return;
}

vsql := "exec dss_list_proc '001', '002'";
rows, e1 := db.Query(vsql)
if e1 != nil{
	fmt.Println(e1);
	return;
}

if rows.Next(){
	fmt.Println("OK")
}

}

[ymofen]

I code direct with go-ole, got the same results....

func TestADORecordSet(t *testing.T) {
	ole.CoInitialize(0)
	defer ole.CoUninitialize()

	unknown, err := oleutil.CreateObject("ADODB.Connection")
	if err != nil {
		fmt.Println(err);
		return;
	}
	db, err := unknown.QueryInterface(ole.IID_IDispatch)
	unknown.Release()
	if err != nil {
		fmt.Println(err);
		return;
	}
	rc, err := oleutil.CallMethod(db, "Open", "Provider=sqloledb;Data Source=127.0.0.1;Initial Catalog=dss_test;User ID=sa;Password=sa@2014")
	if err != nil {
		fmt.Println(err);
		return;
	}
	rc.Clear()
	{
		unknown, err := oleutil.CreateObject("ADODB.recordset")
		if err != nil {
			fmt.Println(err);
			return;
		}
		rs, err := unknown.QueryInterface(ole.IID_IDispatch)
		lvsql := "exec dss_list_proc '001', '002'"

		_, err1 := oleutil.CallMethod(rs, "Open", lvsql, db);
		if err1 != nil {
			fmt.Println(err1);
			return;
		}else{
			unknown, err := oleutil.GetProperty(rs, "Fields")
			if err != nil {
				fmt.Println(err);
				return;
			}
			fields := unknown.ToIDispatch()
			defer fields.Release()
			rv, err := oleutil.GetProperty(fields, "Count")
			if err != nil {
				fmt.Println(err);
				return;
			}
			nc := int(rv.Val)
			rv.Clear()
			cols := make([]string, nc)
			for i := 0; i < nc; i++ {
				var varval ole.VARIANT
				varval.VT = ole.VT_I4
				varval.Val = int64(i)
				val, err := oleutil.CallMethod(fields, "Item", &varval)
				if err != nil {
					fmt.Println(err);
					return;
				}
				item := val.ToIDispatch()
				val.Clear()
				name, err := oleutil.GetProperty(item, "Name")
				if err != nil {
					item.Release()
					fmt.Println(err);
					return;
				}
				cols[i] = name.ToString()
				name.Clear()
				item.Release()
			}
			fmt.Println(cols)
		}
	}

}