none
I'm trying to call a foxpro stored procedure from C#.NET RRS feed

  • Question

  • I'm getting this error

    ERROR [42000] [Microsoft][ODBC Visual FoxPro Driver]Syntax error or access violation

    using(OdbcConnection conn = new OdbcConnection (constants.connetionStringRetailBodega580)) {
                            conn.Open ();
                            var result = new object[1];
                            string sqlProcedure = "{call stkdisponible()}";
    
                            System.Data.Odbc.OdbcDataAdapter da = new OdbcDataAdapter ();
    
    
                            da.SelectCommand = conn.CreateCommand ();
                            da.SelectCommand.CommandType = CommandType.StoredProcedure;
                            da.SelectCommand.CommandText = sqlProcedure;
    
                            OdbcDataReader dr = da.SelectCommand.ExecuteReader ();
                            //OdbcDataReader dr = cmd.ExecuteReader ();
    
    ............
    ...........
    }

    Monday, March 6, 2017 5:07 PM

All replies